Please do not give solution in image format thanku Credit sales:Current monthMay credit salesApril credit salesTotal cash availableLess disbursements:Inventory purchases:Current monthPrior monthXRentSalaries and wagesTaxesXTotal cash needs%%%%Excess of cash available over needs000000002. Conceptual Connection: Did the business show a negative cash balance for June? Production BudgetAssume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $475, and the S12L5 sells for $300. Projected sales (numberof speakers) for the coming five quarters are as follows:S12L7S12L51,1203,0807,8406,4401,260First quarter, 20Y1Second quarter, 20Y1Third quarter, 20Y1Fourth quarter, 20Y1First quarter, 20Y2The vice president of sales believes that the projected sales are realistic and can be achieved by the company.Stillwater Designs needs a production budget for each product (representing the amount that must be outsourced to outside manufacturers). Beginning inventory ofS12L7 for the first quarter of 20Y1 was 340 boxes. The company's policy is to have 20% of the next quarter's sales of S12L7 in ending inventory. Beginning inventory ofS12L5 was 170 boxes. The company's policy is to have 30% of the next quarter's sales of S12L5 in ending inventory.1,8201,9607,4205,4601,680

Production budget is one of the important budget in the business. It shows how many units needs to…

Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $475, and the S12L5 sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 1,120 First quarter, 20Y1 Second quarter, 20Y1 Third quarter, 20Y1 Fourth quarter, 20Y1 First quarter, 20Y2 The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Stillwater Designs needs a production budget for each product (representing the amount that must be outsourced to outside manufacturers). Beginning inventory of S12L7 for the first quarter of 20Y1 was 340 boxes. The company's policy is to have 20% of the next quarter's sales of S12L7 in ending inventory. Beginning inventory of S12L5 was 170 boxes. The company's policy is to have 30% of the next quarter's sales of S12L5 in ending inventory. 3,080 7,840 S12L5 6,440 1,260 1,820 1,960 7,420 5,460 1,680

Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $475, and the S12L5 sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 1,120 First quarter, 20Y1 Second quarter, 20Y1 Third quarter, 20Y1 Fourth quarter, 20Y1 First quarter, 20Y2 The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Stillwater Designs needs a production budget for each product (representing the amount that must be outsourced to outside manufacturers). Beginning inventory of S12L7 for the first quarter of 20Y1 was 340 boxes. The company's policy is to have 20% of the next quarter's sales of S12L7 in ending inventory. Beginning inventory of S12L5 was 170 boxes. The company's policy is to have 30% of the next quarter's sales of S12L5 in ending inventory. 3,080 7,840 S12L5 6,440 1,260 1,820 1,960 7,420 5,460 1,680

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter9: Profit Planning And Flexible Budgets

Section: Chapter Questions

Problem 51E

See similar textbooks

Similar questions

A company produces and sells twò models of product X: X1 and X2. The selling price of X1 is 15 € and X2 is 25 €. The management budgets sales semiannually. Its projection for the first 2 quarters of year 20xx are as follows: Unit sales Product Quarter 1 Quarter 2 X1 20 000 22 000 X2 15 000 12 000 No cahnges in selling prices are anticipated. The task: Prepare a sales budget for the 2 quarters ending June 30, 20xx. List the products and show for each quarter and the 6 months, units, selling price, and total sales by product and in total.
Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $475, and the S12L5 sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 S12L5 First quarter, 20Y1 840 1,365 Second quarter, 20Y1 2,310 1,470 Third quarter, 20Y1 5,880 5,565 Fourth quarter, 20Y1 4,830 4,095 First quarter, 20Y2 945 1,260 The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Stillwater Designs needs a production budget for each product (representing the amount that must be outsourced to manufacturers located in Asia). Beginning inventory of S12L7 for the first quarter of 20Y1 was 340 boxes. The company's policy is to have 20% of the next quarter's sales of S12L7 in ending inventory. Beginning inventory of S12L5 was 170 boxes. The company's policy is to have 30% of the next quarter's sales of S12L5 in ending…
Sales Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $656, and the S12L5 sells for $414. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 S12L5 First quarter, 20Y1 800 1,300 Second quarter, 20Y1 2,200 1,400 Third quarter, 20Y1 5,600 5,300 Fourth quarter, 20Y1 4,600 3,900 First quarter, 20Y2 900 1,200 The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Required: Prepare a sales budget for each quarter of 20Y1 and for the year in total. Show sales by product and in total for each time period. Do not include a multiplication symbol as part of your answer. Stillwater Designs Sales Budget For the Year Ended December 31, 20Y1 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Year S12L7: Units Price $ $ $ $ $ Sales $ $ $ $ $ S12L5: Units Price $ $ $ $ $…
Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $475, and the S12L5 sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 S12L5 First quarter, 20Y1 1,120 1,820 Second quarter, 20Y1 3,080 1,960 Third quarter, 20Y1 7,840 7,420 Fourth quarter, 20Y1 6,440 5,460 First quarter, 20Y2 1,260 1,680 The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Stillwater Designs needs a production budget for each product (representing the amount that must be outsourced to manufacturers located in Asia). Beginning inventory of S12L7 for the first quarter of 20Y1 was 340 boxes. The company's policy is to have 20% of the next quarter's sales of S12L7 in ending inventory. Beginning inventory of S12L5 was 170 boxes. The company's policy is to have 30% of the next quarter's sales of S12L5 in ending…
Sales Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $627, and the S12L5 sells for $396. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 S12L5 First quarter, 20Y1 800 1,300 Second quarter, 20Y1 2,200 1,400 Third quarter, 20Y1 5,600 5,300 Fourth quarter, 20Y1 4,600 3,900 First quarter, 20Y2 900 1,200 The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Required: Prepare a sales budget for each quarter of 20Y1 and for the year in total. Show sales by product and in total for each time period. Do not include a multiplication symbol as part of your answer. 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Year S12L7: Units fill in the blank 2f6b2604ff91fe0_1 fill in the blank 2f6b2604ff91fe0_2 fill in the blank 2f6b2604ff91fe0_3 fill in the blank 2f6b2604ff91fe0_4 fill in the blank 2f6b2604ff91fe0_5…
Bonita Company estimates that unit sales will be 11,600 in quarter 1, 16,240 in quarter 2, 17,400 in quarter 3, and 20,880 in quarter 4. The unit selling price is $70. Management desires to have an ending finished goods inventory equal to 25% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first 6 months of 2022. BONITA COMPANY Production Budget 1 11,600 Quarter 2 16,240 Six Months
What is the production budgeted for the third quarter? Company policy is to have a finished goods inventory at the end of each quarter equal to 18 percent of the next quarter's sales. The sales budget for Your Company’s projected quarterly sales for next years as follows: Quarter 1: 55,000 units Quarter 2: 18,000 units Quarter 3: 22,000 units Quarter 4: 44,000 units Group of answer choices 25,950 17,280 18,040 18,720
Infinity Inc. has provided the following projected sales units for the next quarter: Projected Sales First month Second month Third month Projected sales units 20,000 25,000 30,000 Desired ending inventory is determined to be 12% of the next month’s projected sales. What would be the budgeted production units during the second month of the quarter? Group of answer choices 25,600 units 28,600 units 31,600 units 26,400 units
Infinity Inc. has provided the following projected sales units for the next quarter: Projected Sales Units for Next Quarter Sales Units First month Second month Third month Projected sales units 10,000 12,000 15,000 Desired ending inventory is determined to be 10% of the next month’s projected sales. What would be the budgeted production units during the second month of the quarter? Group of answer choices 12,300 units 13,200 units 11,700 units 13,500 units
Blossom Company estimates that unit sales will be 8,000 in quarter 1, 11,200 in quarter 2, 12,000 in quarter 3, and 14,400 in quarter 4. The sales price is $70 per unit. Management desires to have an ending finished goods inventory equal to 25% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first 6 months of 2022. Expected Unit Sales Add V: Desired Ending Finished Goods Inventory Total Required Units Less V: Beginning Finished Goods Inventory Required Production Units BLOSSOM COMPANY Production Budget For the Six Months Ending June 30, 2022 V 1 8000 2800 10800 Quarter D 11200 3000 14200 Six Months
Crane Company estimates that unit sales will be 8,000 in quarter 1,11,200 in quarter 2, 12,000 in quarter 3, and 14,400 in quarter 4. Using a unit selling price of $68 per unit. Prepare the sales budget by quarters for the year ending December 31, 2022. CRANE COMPANY Sales Budget Quarter 3 Year $ $ es es
What is the production budgeted for the second quarter? Company policy is to have a finished goods inventory at the end of each quarter equal to 18 percent of the next quarter's sales. The sales budget for Your Company's projected quarterly sales for next years as follows: Quarter 1: 44,000 units Quarter 2: 35,000 units Quarter 3: Quarter 4: 42,000 units 55,000 units O 44,340 33,740 36,260 O 39,660