The vice-president of sales and marketing. Madison Tremblay, is trying to plan for the coming year in terms of production needs to meet the forecast sales. The board of directors is very supportive of any initiatives that will lead to increased operating income for the company in the upcoming year. Waterways markets a simple water controller and timer that it mass-produces. During 2022, the company sold 322.500 units at an average selling price of $8.00 per unit. The variable costs were $1,193,250. and the fixed costs were $606,300.

The vice-president of sales and marketing. Madison Tremblay, is trying to plan for the coming year in terms of production needs to meet the forecast sales. The board of directors is very supportive of any initiatives that will lead to increased operating income for the company in the upcoming year. Waterways markets a simple water controller and timer that it mass-produces. During 2022, the company sold 322.500 units at an average selling price of $8.00 per unit. The variable costs were $1,193,250. and the fixed costs were $606,300.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter18: Cost-volume-profit Analysis (cvp)

Section: Chapter Questions

Problem 1R: Poleski Manufacturing, which maintains the same level of inventory at the end of each year, provided...

See similar textbooks

Similar questions

Coronado Enterprises is a boutique guitar manufacturer. The company produces both acoustic and electric guitars for rising and established professional musicians. Sharon Lee, the company’s sales manager, prepared the following sales forecast for 2022. The forecasted sales prices include a 5% increase in the acoustic guitar price and a 10% increase in the electric guitar price, to cover anticipated increases in raw materials prices. Sales Price 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Acoustic guitar sales $1,250 240 270 310 340 Electric guitar sales $2,100 400 350 320 360 On December 31, 2021, Coronado had 30 acoustic guitars in stock—fewer than the desired inventory level of 96 guitars, based on the following quarter’s sales. The company has budgeted for sales of 240 acoustic guitars in the first quarter of 2023. Prepare the 2022 production budget for acoustic guitars. Production…
Swifty Enterprises is a boutique guitar manufacturer. The company produces both acoustic and electric guitars for rising and established professional musicians. Patricia Johnson, the company’s sales manager, prepared the following sales forecast for 2022. The forecasted sales prices include a 5% increase in the acoustic guitar price and a 10% increase in the electric guitar price, to cover anticipated increases in raw materials prices. Sales Price 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Acoustic guitar sales $1,200 200 280 320 350 Electric guitar sales $2,150 400 350 320 360 Please help me fill out the red shown in the picture.
Coronado Enterprises is a boutique guitar manufacturer. The company produces both acoustic and electric guitars for rising and established professional musicians. Sharon Lee, the company’s sales manager, prepared the following sales forecast for 2022. The forecasted sales prices include a 5% increase in the acoustic guitar price and a 10% increase in the electric guitar price, to cover anticipated increases in raw materials prices. Sales Price 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Acoustic guitar sales $1,250 240 270 310 340 Electric guitar sales $2,100 400 350 320 360 (a) Prepare Coronado’s sales budget for 2022. Sales Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual Acoustic: select a sales budget item enter a number of units enter a number of units…
Relling Corporation manufactures a drink bottle, model CL24. During 2017, Relling produced 210,000 bottles at a total cost of $808,500. Kraff Corporation has offered to supply as many bottles as Relling wants at a cost of $3.75 per bottle. Relling anticipates needing 225,000 bottles each year for the next few years. Q. What other information would you need to be confident that the equation in requirement 2 accurately predicts the cost of manufacturing drink bottles?
Wildhorse Enterprises is a portable hot tub manufacturer. The company produces both 2-person and 4-person hot tubs. Chris Anderson, the company's sales manager, prepared the following sales forecast for 2021. The forecasted sales prices include a 5 percent increase in the 2-person spa price and a 10 percent increase in the 4-person spa price, to cover anticipated increases in raw materials prices. 2-person spa 4-person spa (a) on spas: Your answer is partially correct. geted sales price Prepare Wildhorse's sales budget for 2021. geted sales price ✓ il revenue on spas: Sales Price geted sales price geted sales price geted sales price v frevenue V $1,400 $2,700 V 1st Quarter 650 350 LA 1A 1st Quarter 2nd Quarter 910000 490000 1400000 DE 650 Units 250 3rd Quarter 550 250 2nd Quarter 4th Quarter 910000 350000 1260000 750 350 SA 3rd Quarter 1050000 490000 1540000 SA SA SA SA FA 1
Crane, LLC is a small company that sells decorative picture frames from local artisans. John, the chief financial officer (CFO), is in the process of compiling a Budgeted Income Statement for 2024 so that the company can apply for a loan at the local bank. John has budgeted for sales of 6,300 mugs at a sales price of $15.00 per mug. The company originally paid $5.00 per mug when it acquired them. The company has selling, general & admin (SG&A) expenses of $47,600 and an existing loan of $7,500 with an annual percentage rate (APR) of 3.0%. The tax rate is a flat 21%.
A young entrepreneur founded a packaged beverage company in early 2022. Based on information gathered from consumers, the young entrepreneur plans to increase sales of packaged drinks in 2023, by producing packaged drinks with new flavors.Revenue in 2022 is $500,000 and is expected to reach $1,500,000 in 2023. Each bottled beverage will sell for $5, and the bottled beverage costs $2 per bottle to produce. Administrative costs including the young entrepreneur’s salary, salary of one accountant and three clerks, are estimated at $200,000 and marketing costs such as posters, advertisements in local newspapers, are estimated at $350,000 in 2023. Then, investment in special equipment and renovation of Warehouses accounts for $562,500 and $62,500 in inventory, which was done in 2022. Moreover, an additional $150,000 in equipment investment is expected to be needed in early 2023 to increase the production volume of their bottled beverage. Currently, the old machine is still capable of…
Al Khalid LLC are the manufacturers of Lamps. The following are the details of their operation during 2020. Average monthly market demand is 2,000 lamps, ordering cost is RO 200 per order, inventory carrying cost is 20 percent per annum, cost of lamps is RO 1,000 per lamp, normal usage is 100 lamps per week, minimum usage is 50 lamps per week, maximum usage is 200 lamps per week and lead time to supply 4 -6 weeks. You are required to calculate the maximum level of stock. a. 1120 units b. 1102 units c. 1063 units d. 1302 units
Calico Restaurants is planning to create a new online meals-to-order service and has estimated that creating it will have the following effects on its operations: a. Annual revenues will increase from $800,000/year to $1,300,000/year, for the next 3 years. b. While the restaurant earns an EBITDA margin (EBITDA as percent of sales) of 30% currently, it expects to earn an EBITDA margin of 40% on just its incremental online sales. c. The tax rate is 20% and the appropriate cost of capital for online restaurant businesses is 12%. Assuming that there will be an initial cost of $450,000 for creating the service, which will be depreciated straight line over 3 years to a salvage value of zero, estimate the NPV for the investment. a. 112,365 b. 9,865 C. -2,354 d. 6,348
Garcia Corporation manufactures a drink bottle, model CL24. During 2020, Garcia produced 190,000 bottles at a total cost of $674,500. Beecher Corporation has offered to supply as many bottles as Garcia wants at a cost of $3.45 per bottle. Garcia anticipates needing 205,000 bottles each year for the next few years. Read the requirements. Requirement 1a. What is the average cost of manufacturing a drink bottle in 2020? How does it compare to Beecher's offer? The average cost of per bottle is than Beacher's offer Requirement 1b. Can Garcia use the answer in requirement 1a to determine the cost of manufacturing 205,000 drink bottles? Explain. take the average manufacturing cost in 2020 to determine the total cost of manufacturing 205,000 drink bottles. The reason is that Garcia Requirement 2. Garcia's cost analyst uses annual data from past years to estimate the following regression equation with total manufacturing costs of the drink bottle as the dependent variable and drink bottles…
Dublin Chips is a manufacturer of prototype chips based in Dublin, Ireland. Next year, in 2018, Dublin Chips expects to deliver 615 prototype chips at an average price of $95,000. Dublin Chips’ marketing vice president forecasts growth of 65 prototype chips per year through 2024. That is, demand will be 615 in 2018, 680 in 2019, 745 in 2020, and so on. The plant cannot produce more than 585 prototype chips annually. To meet future demand, Dublin Chips must either modernize the plant or replace it. The old equipment is fully depreciated and can be sold for $4,200,000 if the plant is replaced. If the plant is modernized, the costs to modernize it are to be capitalized and depreciated over the useful life of the updated plant. The old equipment is retained as part of the modernize alternative. The following data on the two options are available:…
Dublin Chips is a manufacturer of prototype chips based in Dublin, Ireland. Next year, in 2018, Dublin Chips expects to deliver 615 prototype chips at an average price of $95,000. Dublin Chips’ marketing vice president forecasts growth of 65 prototype chips per year through 2024. That is, demand will be 615 in 2018, 680 in 2019, 745 in 2020, and so on. The plant cannot produce more than 585 prototype chips annually. To meet future demand, Dublin Chips must either modernize the plant or replace it. The old equipment is fully depreciated and can be sold for $4,200,000 if the plant is replaced. If the plant is modernized, the costs to modernize it are to be capitalized and depreciated over the useful life of the updated plant. The old equipment is retained as part of the modernize alternative. The following data on the two options are available:…