Sparks Corp. manufactures knee braces and other orthopedic supplies. Knee braces sell for $175 each. Sparks Corp. projects sales for April will be 680 braces, with sales increasing by 85 braces per month for May, June and July. At the beginning of April Sparks Corp. has 135 braces on hand but desires to maintain an ending inventory of 10% of the next month's sales. Prepare the sales budget and production budget for Sparks Corp. for the months of April, May and June.
Q: The budget director of Peaky Blinders Furniture Company requests estimates of sales, production, and…
A: Direct costs are the expenses that are directly used for the production of goods and services for…
Q: At what amounts should each of the three assets be
A: Cost of the assets is calculated on the basis of the fair value of the assets.The fair value of each…
Q: Compute the balance in each of the following accounts at December 31, 2025, and December 31, 2026
A: The company runs the business with assets such as land, building, computer, and motor vehicles.…
Q: 1. Prepare a schedule, for the remaining 3 years, reflecting whether CH should upgrade its…
A: Relevant cost is the cost which can affect the decision of the firm regarding a line of business.…
Q: 18. The phone number listed on a résumé: A. Phone numbers should not be listed on a résumé B. Should…
A: The objective of these questions is to understand the best practices when it comes to creating a…
Q: Appendix: carrying costs Determine the carrying costs for an item costing $6.80, given the following…
A: Annual carrying cost is the cost Incurred to hold the inventory. It includes warehouse cost,…
Q: The following materials standards have been established for a particular product: Standard quantity…
A: variance is an difference between the actual and standard cost of production data.The variance can…
Q: Bond premium, entries for bonds payable transactions Rodgers Corporation produces and sells football…
A: The bonds are issued to raise the money from the market or investors. The bonds are reported as the…
Q: iv) v) vi) Calculate the cash flow from assets Calculate net capital spending Calculate change in…
A: Cash flow from assets is the total cash flow to creditors and cash flow to stockholders, consisting…
Q: Presented below are two independent situations: Click here to view factor tables. (a) On January 1,…
A: A zero-interest-bearing note is a debt that does not include the written obligation that the…
Q: Espresso Express operates a number of espresso coffee stands in busy suburban malls. The fixed…
A: Fixed Cost is the cost that remains fixed in total irrespective of the level of output. The cost…
Q: Compute the amounts of any liability for compensated absences that should be reported on the balance…
A: 1. December 31, 202510 employees * $11.80/hr. * 8 hrs./day * 11 days =$10,384
Q: Required information [The following information applies to the questions displayed below.) Sweeten…
A: The overhead rate is a cost that is allocated to the product or service at the time of production.…
Q: Locate the Competition Act, R.S.C., 1985, c. C-34. Below the long title of the legislation, it…
A: The Competition Act, R.S.C., 1985, c. C.34, is a Canadian federal law that governs competition and…
Q: On January 1, 2021, the Taylor Company adopted the dollar-value LIFO method. The inventory value for…
A: The inventory can be valued using various methods. The various methods for inventory valuation are…
Q: ZZZ INC bought a computer (5-year property) on July 31 with a basis of $5,500 and some machinery…
A: Depreciation is an accounting method which is used to spread the cost of an asset over its useful…
Q: Riverbed Cole Inc. acquired the following assets in January of 2018. Equipment, estimated service…
A: First, calculate the accumulated depreciation at the end of 3 years using the Sum-of-Digit…
Q: On January 1, 2024, Sheridan Ltd. leased a machine from Carla Vista Equipment Ltd. The machine had…
A: Leasing typically refers to the contractual arrangement where one party, known as the lessor, grants…
Q: Abbott Business Services (ABS) generated revenue of $653,800 processing accounts payable and payroll…
A: The activity-based costing allocates costs based on the activities consumed by each product. It also…
Q: Problem 14-58 (LO 14-5) Roberto has a basis of $6,000 in a partnership at the beginning of the year.…
A: Partnership refers to the type of company that has two or more than two owners. Under the…
Q: Required information The Foundational 15 (Algo) [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-7, LO6-8]…
A: The break-even point in units sales is a critical concept in business and finance. It represents the…
Q: Required: Prepare Shadee's budgeted Income statement for the months of May and June. Note: Do not…
A: Contribution means the difference between the sale and variable cost. Net operating income means the…
Q: The following data are available pertaining to Household Appliance Company's retiree health care…
A: Calculation of the given requirements:Formulas for the above table are given below:
Q: [The following information applies to the questions displayed below.) Westerville Company reported…
A: An investment's profitability and efficiency are assessed using a (ROI), which compares an…
Q: 9. Which is not an aspect of a report to make it effective? a. Detailed b. Accuracy c. Relevance d.…
A: The aspect of a report that is not considered essential for its effectiveness is:a. DetailedWhile…
Q: Required information Exercise 11-16 (Algo) Effects of Changes in Sales, Expenses, and Assets on ROI…
A: RETURN ON INVESTMENTReturn on investment is one of the profitability ratios which shows how much…
Q: Assume that there are 2 chartered banks and their T-accounts are below. Suppose that there are…
A: (1) The Below are the two main functions of a bank:Accepting Deposit: A bank provides a safe place…
Q: Required (a) Should Brackley Co. accept the order or not? (b) If Brackley Co. had no spare capacity…
A: (a) To determine whether Brackley Co. should accept the order or not, we will perform a contribution…
Q: Logistics Solutions provides order fulfillment services for dot.com merchants. The company maintains…
A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: Swifty Paints makes various interior and exterior paints for its customers, but its current focus is…
A: Operation costing method employed to determine the value of a product at each process or stage of…
Q: MotoSport is buying an asset that costs $730,000 and can be depreciated at 20 percent per year…
A: Resources that are used by a business or an individual are called assets. Examples of a person's…
Q: For each of the following depreciable assets, determine the missing amount. Abbreviations for…
A: Straight-Line Depreciation (SL):Meaning: Straight-Line Depreciation is a method of allocating the…
Q: Intermediate Accounting 105 May I please have a GAAP explanation, along with examples providing…
A: The objective of the question is to understand the conditions under which a short-term obligation…
Q: The Gonzalez Group issued $980,000 of 9% bonds on June 30, 2024, for $1,076,985. The bonds were…
A: Bonds payable refers to a type of long-term debt that a company or organization issues to borrow…
Q: Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses as…
A: Income statement is the one which is prepared by the entity for the purpose of determining the…
Q: A company fails to record accrued wages for the current year. Which of the following statement is…
A: The accrued wages are the wages that are due for payment but not paid yet. The accrued wages are…
Q: journalize the adjusting entry for bad debt expense
A: A bad debt expense is recognized when a receivable is no longer collectible because a customer is…
Q: Clothing Retail Store's accountant prepared the following income statement for the teenagers'…
A: Incremental Analysis: Incremental analysis refers to the analysis of differential revenue that could…
Q: Taylor's tractor-trailer rigs sell for $150,000. A customer wishes to buy a rig on a dease purchase…
A: A lease is a legal agreement in which one party gives another party the use of real estate or land…
Q: How can fraud be prevented in the making use of accounting information systems? How do ethics and…
A: The objective of this question is to understand the measures that can be taken to prevent fraud in…
Q: Required information Skip to question [The following information applies to the questions…
A: The objective of this question is to prepare the journal entries for the sale of a grandfather clock…
Q: Michael Smith, a dealer in securities b
A: A “realized gain” occurs when the sales price is greater than the cost basis. A “recognized gain” is…
Q: On January 13, 2025, Cullumber Corporation discovered that goods in transit of $113,025 with terms…
A: The FOB shipping point indicates that ownership of the goods shifts to the buyer when the seller…
Q: Beginning inventory, purchases, and sales for an inventory item are as follows: Date Line Item…
A: INVENTORY VALUATIONInventory Valuation is a Method of Calculation of Value of Inventory at the End…
Q: The Bradford Company issued 12% bonds, dated January 1, with a face amount of $86 million on January…
A: Bonds meaning:- Bonds are debt securities or financial instruments issued by governments,…
Q: You and your spouse wish to give each of your three grandchildren a yearly tax-free gift from your…
A: In 2023, the Internal Revenue Service (IRS) allows individuals to give up to $17,000 per recipient…
Q: [The following information applies to the questions displayed below.] Vanishing Games…
A: Income statement is one of useful financial statement being prepared in business. It shows all…
Q: At year-end, the perpetual inventory records of Monty Company showed merchandise inventory of…
A: The journal entries are prepared to record the transactions on regular basis. The adjustment entries…
Q: How was net income in question 4 determined?
A: A consolidated net income is an income which is required to be determined when there has been a…
Q: The company constructed a building in 20X0 for a total cost of €70,000. For the construction of the…
A: The objective of the question is to determine the accounting treatment of the interest for the years…
Sparks Corp. manufactures knee braces and other orthopedic supplies. Knee braces sell for $175 each. Sparks Corp. projects sales for April will be 680 braces, with sales increasing by 85 braces per month for May, June and July. At the beginning of April Sparks Corp. has 135 braces on hand but desires to maintain an ending inventory of 10% of the next month's sales.
Prepare the sales budget and production budget for Sparks Corp. for the months of April, May and June.
Step by step
Solved in 3 steps
- Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,500 March 13,700 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: a. Finished goods inventory on January 1 is 900 units. The desired ending inventory for each month is 20 percent of the next month's sales. b. The data on materials used are as follows: Direct Material Per-Unit Usage Unit Cost Part #1298 2 $4 4 Part #C30 3 7 Inventory policy dictates that sufficient materials be on hand at the beginning of the month to satisfy 30 percent of the next month's production needs. This is exactly the amount of material on hand on January 1. c. The direct labor used per unit of output is one and…me * CengageNOWv2 | Online teachin X eAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator%=&inprogress%-false еВook Show Me How E Print Item Production Budget Pasadena Candle Inc. projected sales of 800,000 candles for January. The estimated January 1 inventory is 35,000 units, and the desired January 31 inventory is 20,000 units. Prepare a production budget report in units for Pasadena Candle Inc. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Pasadena Candle Inc. Production Budget For the Month Ending January 31 Expected units to be sold Desired ending inventory, January 31 Total units available Estimated beginning inventory, January 1 Total units to be produced in January Feedback Check My VWork Remember to take into account expected units to be sold, desired units in ending inventory and estimated units in beginning inventory when calculating total units to be produced. Previous Nextome * CengageNOWv2 | Online teachin x keAssignment/takeAssignmentMain.do?invoker-&takeAssignmentSessionLocator=&inprogress=false Production Budget Pasadena Candle Inc. projected sales of 51,000 candles for January. The estimated January 1 inventory is 2,000 units, and the desired January 31 inventory is 6,000 units. Prepare a production budget report in units for Pasadena Candle Inc. For those boxes in which you must enter subtracted ar negative numbers use a minus sign. Pasadena Candle Inc. Production Budget For the Month Ending January 31 Expected units to be sold 51,000 Desired ending inventory, January 31 Total units available Estimated beginning inventory, January 1 2,000 Total units to be produced in January
- Kis Minda 8 Exercise 4-25 A sales budget for the first five months of 2021 is given on a certain product line manufactured by Boots Styles, Inc. Sales budget in units 157,000 January 162,000 February 204,000 March 223,000 April May 245,000 The inventory of finished products at the end of each month is equal to 20% of the sales estimate for the next month. This requirement is expected to be met by Jan. 1. No work is in process at the end of each month. Each unit of product requires two types of raw materials as follows: Material A 2 unit Material B 6 units The estimated cost of Material A is P5.00 per unit, and the estimated cost of Material B is PO.60 per unit. Materials equal to 30% of next month's production needs are to be on hand at the end of each month. This requirement is expected to be met on Jan. 1. REQUIRED: 1. Prepare a production budget for the first quarter of 2021 broken down by months. Include a total column. 2. Prepare a purchases budget for each type of raw materials…Sales and Production Budgets Bass Audio Company manufactures two models of speakers, U500 and S1000. Based on the following production and sales data for J U500 s1000 Estimated inventory (units), June 1 227 56 Desired inventory (units), June 30 261 49 Expected sales volume (units): Northeast Region 2,200 1,950 Southwest Region 5,250 4,550 Unit sales price $125 $185 a. Prepare a sales budget. Enter all amounts as positive numbers. BASS AUDIO COMPANY Sales Budget For the Month Ending June 30 Unit Sales Unit Sales Product and Area Total Sales Volume Price Model U500: Northeast Region 2,200 V 125 275,000 V Southwest Region 5,250 V 656,250 V 125 Total 7,450 V 931,250 V Model S1000: Northeast Region 1,950 V 185 360,750 V Southwest Region 4,550 V 185 V 841,750 V Total 6,500 V 1,202,500 Total revenue from sales 2,133,750Clark Company's master budget reflects budgeted sales information for the month of June, 2022 as follows: Product A Product B Budgeted Quantity 40,000 48,000 Budgeted Unit Sales Price $7 $9 During June, the company actually sold 39,000 units of Product A at an average unit selling price of $7.1 and 49,600 units of Product B at an average unit price of $8.9. Prepare a Sales Budget Report for the month of June for Clark Company which shows whether the company achieved its planned objectives.
- Function: SUM; Formula: Subtract, Multiply; Cell Referencing Using Excel to Prepare a Production Budget PROBLEM Paige Company estimates that following unit sales and desired inventory level for the four quarters of the year ending December 31, 2022. Quarter 1 sales Quarter 2 sales Quarter 3 sales Quarter 4 sales Desired ending finished goods inventory based on next quarter's expected unit sales Unit selling price 10,000 14,000 15,000 18,000 25% $ 70.00 Prepare a production budget by quarters for the first 6 months of 2022. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or this work area as indicated. Use the SUM function with cell referencing for totals. Paige Company Production Budget For the Six Months Ending June 30, 2022 Quarter 1 10,000 Expected unit sales Add: Desired ending finished goods units Total required units Less: Beginning finished goods units Required production…Use the spreadsheet extract to answer the questions 1 A B Materials budgets: 50mm x 20mm pine C D E F 2 3 4 5 Usage budget September October November Total units units units units 6 7 Production of tables 250 280 290 820 8 9 metres 10 Raw material usage 625 metres 700 metres 725 metres ? 11 12 13 Purchases budget metres metres metres metres 14 Production usage 625 700 725 ? 15 Add: closing stock 28 29 30 ? 16 Less: opening stock (25) (28) (29) ? 17 Purchases 628 701 726 2055 18 19 $ $ 20 21 Raw material purchases 5903.20 6589.40 6824.40 19317.00 22 23 24 Raw materials data 25 Usage per unit of production (metres) 2.5 26 Purchase price per metre ($) 9.40 27 28 29 Assumptions 1 The closing stock in one month is 4% of the following month's production requirement 30 2 From December onwards production of tables will plateau at 290 Required Which of the following cells require the input of an actual value rather than formula relating to another cell on the spreadsheet? B15 Suggest a formula…LearnCo Sales Budget For the Year Ending December 31, 20Y2 Product Unit Sales Volume Unit Selling Price Total Sales Basic Abacus 36,000 $7.00 $252,000 Deluxe Abacus 36,000 $13.00 468,000 Totals 72,000 $720,000 LearnCo Production Budget For the Year Ending December 31, 20Y2 Units Basic Units Deluxe Expected units to be sold (from Sales Budget) 36,000 36,000 Desired ending inventory, December 31, 20Y2 1,000 3,000 Total units available 35,000 33,000 Estimated beginning inventory, January 1, 20Y2 (1,050) (2,100) Total units to be produced 33,950 30,900 The direct materials purchases budget should be integrated with the production budget to ensure that production is not interrupted during the year. This budget estimates the quantities of direct materials to be purchased to support budgeted production, along with desired inventory levels of direct materials. Before you make any changes to the budget, you review the information…
- dgeting Activity-03/25/ x + ses/115610/quizzes/1740321/take ABC Company has a policy of maintaining an inventory of finished goods equal to 25% of the following month's sales units. For the forthcoming month of June, the budgeted beginning inventory is at 20,000 units and the ending inventory at 22,000 units. The following are the budgeted sales for the months of August to October August 90,000 September 92,000 October 94,500 The sales price the finished goods per unit is P150 based on gross profit rate (on cost) of 15%. October ending inventory is estimated to be at 20% less than September's. Operating expenses were estimated as follow: Seling expense is at 2.75% of sales Salary expense is at P5,000 + 3% of sales General and Administrative Expense is at P40,000 per month Number of units available for sale for the month of July Format XXX,XXX i.e. 123,850 Question 4Symphony Electronics produces wireless speakers for outdoor use on patios, decks, etc. Their most popular model is the All Weather and requires four separate XL12 components per unit. The company is now planning raw material needs for the second quarter. Sales of the All Weather are the highest in the second quarter of each year as customers prepare for the summer season. The company has the following inventory requirements: a. The finished goods inventory on hand at the end of each month must be equal to 15,700 units plus 10% of the next month's sales. The finished goods inventory on March 31 is budgeted to be 28,600 units. b. The raw materials inventory on hand at the end of each month must be equal to 20% of the following month's production needs for raw materials. The raw materials inventory on March 31 for XL 12 is budgeted to be 97,600 components. c. The company maintains no work in process inventories. A sales budget for the All Weather speaker is as follows: April May June July…Requirement 1. Prepare a production budget for each month in the first quarter of the year, including production in units for each month and for the quarter. Gable Manufacturing Production Budget For the Months of January through March January February March Quarter Unit sales 3,900 3,700 3,100 10,700 Plus: Desired ending inventory 370 310 450 450 Total needed 4,270 4,010 3,550 11,150 Less: Beginning inventory 390 370 310 390 Units to produce 3,880 3,640 3,240 10,760 Part 2 Requirement 2. Prepare a direct materials budget for the polypropylene for each month in the first quarter of the year, including the pounds of polypropylene required and the total cost of the polypropylene to be purchased. Start by preparing the direct materials budget through the total quantity needed, then complete the budget. Gable Manufacturing Direct Materials Budget For the Months of January through March January February March Quarter Units to be produced Multiply by: Quantity of direct materials needed…