b. Prepare a production budget.SONIC INC.Production BudgetFor the Month Ending June 30Expected units to be soldPlus desired inventory, June 30Total units requiredLess estimated inventory, June 1Total units to be producedUnits Model Rumble Units Model Thunder EX.22-06 Sales and Production BudgetsSonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the followingproduction and sales data for June, prepare (a) a sales budget and (b) a production budget.Estimated inventory (units), June 1Desired inventory (units), June 30Expected sales volume (units):East RegionWest RegionUnit sales priceRumble2623012,7005,900$140Thunder66572,4005,150$205

a. Preparation of the sales budget is follows.ParticularsRumbleThunderEast Region (a)27002400West…

Answered: EX.22-06 Sales and Production Budgets

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

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…
On the production budget, the number of units to be produced is computed as Select one: a. unit sales + desired end inventory + beginning inventory. b. unit sales - desired end inventory - beginning inventory. c. unit sales - desired end inventory + beginning inventory. d. unit sales + desired end inventory - beginning inventory. e. unit sales - cost of goods sold + beginning inventory. PreviousSave AnswersNext
Symphony 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 16,400 units plus 10% of the next month's sales. The finished goods inventory on March 31 is budgeted to be 28,700 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 98,800 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…
EX.22-06 Sales and Production Budgets Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget. Estimated inventory (units), June 1 Desired inventory (units), June 30 Expected sales volume (units): East Region West Region Unit sales price Rumble 262 301 2,700 5,900 $140 Thunder 66 57 2,400 5,150 $205
QS 21-4 Flexible budget performance report P1 The fixed budget for 20,000 units of production shows sales of $400,000; variable costs of $80,000; and fixed costs of $150,000. The company's actual sales were 26,000 units at $480,000. Actual variable costs were $112,000 and actual fixed costs were $145,000. Prepare a flexible budget performance report. Indicate whether each variance is favorable or unfavorable. Page 847
Question 7 Landon Inc. projected sales of 31,000 personal journals for 20Y6. The estimated January 1, 20Y6, inventory is 2,200 units, and the desired December 31, 20Y6, inventory is 3,000 units. What is the budgeted production (in units) for 20Y6?fill in the blank 1 units
Exercise 21-4 (Algo) Preparing flexible budget performance report LO P1 Complete the following partial flexible budget performance report, and indicate whether each variance is favorable or unfavorable. The company budgets a selling price of $85 per unit and variable costs of $34 per unit. (Indicate the effect of each variance by selecting favorable, unfavorable, or no variance.) For Month Ended June 30 Sales Variable costs Contribution margin Fixed costs Income Flexible Budget Performance Report Flexible Budget Actual Results (12,300 units) (12,300 units) 627,300 285,000 366,000 300,000 Variances Favorable/Unfavorable $ 44,500 Favorable
6. In developing an annual financial budget, what would directly affect the direct labor budget? - Group of answer choices - production budget - sales forecast - schedule of cash receipts and disbursements
(J) please answer ASap... Question 1 The following table presents selected information for Superior Flooring's monthly production budgets for the coming year. Superior's inventory policy is to have ending inventory equal to 10% of the next month's sales. What is the beginning inventory in June? A. 350 B. 310 C. 250 D. 340 Question 2 Which of the following statements is true? A. A budget reconciliation report shows the difference between actual profit and budgeted profit and does not show the other variances. B. Activity-based costing is not used to evaluate customer profitability. C. Sales quantity (budgeted sales volume vs. actual sales volume) is the only item which differs between the master budget and the flexible budget. D. Comparing the flexible budget to the as-if budget isolates a change in input price (e.g. budgeted input price vs. actual input price). Question 3 Which of the following is not a benefit of budgeting? A. It reduces the need for analysis with regard to company…
Question 32 The following information is taken from the production budget for the first quarter: Sales budgeted for the quarter 684,000 units Desired ending finished goods Beginning inventory in units 4,800 units 1,800 units How many units should the company produce during the quarter? 681,000 a. Ob. 688,800 Oc. 687,000 711,000
Marigold manufactures aluminum canoes. In planning for the coming year, CFO Alexis King is considering three different sales targets: 2,690 canoes, 3,340 canoes, and 3,880 canoes, Canoes sell for $950 each. The standard variable cost information for a canoe is as follows. Direct materials Direct labor Variable overhead Utilities Indirect material Indirect labor Total Insurance $264 Rent 110 Total 35 30 Annual fixed overhead cost is expected to be: 60 Maintenance $ 21,700 Depreciation 43,000 29,600 32,380 $ 126,680 $ 499

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS