Function: SUM; Formula: Subtract, Multiply; Cell ReferencingUsing Excel to Prepare a Production BudgetPROBLEMPaige Company estimates that following unit sales and desiredinventory level for the four quarters of the year ending December 31,2022.Quarter 1 salesQuarter 2 salesQuarter 3 salesQuarter 4 salesDesired ending finished goods inventorybased on next quarter's expected unit salesUnit selling price10,00014,00015,00018,00025%$ 70.00Prepare a production budget by quarters for the first 6 months of 2022.Student Work AreaRequired: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cellreferences to the Problem area or this work area as indicated. Use the SUM function with cell referencingfor totals.Paige CompanyProduction BudgetFor the Six Months Ending June 30, 2022Quarter 110,000Expected unit salesAdd: Desired ending finished goods unitsTotal required unitsLess: Beginning finished goods unitsRequired production units3Quarter 214,000Six Months

A production budget is a financial plan that outlines the estimated number of units to be produced…

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.

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.

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

Chapter3: Cost Behavior And Cost Forecasting

Section: Chapter Questions

Problem 27BEB: Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Refer...

See similar textbooks

Similar questions

Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Refer to the information for Speedy Petes above. Assume that this information was used to construct the following formula for monthly delivery cost. TotalDeliveryCost=41,850+(12.00NumberofDeliveries) Required: Assume that 3,000 deliveries are budgeted for the following month of January. Use the total delivery cost formula for the following calculations: 1. Calculate total variable delivery cost for January. 2. Calculate total delivery cost for January.
Integrated Excel: Preparing a Contribution Format Income Statement Using the High-Low Method Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution format income statement. Budgeted information for Quarter 1 of 2024: Sales in units Sales price per unit After analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) Sales Commissions (per dollar of sales). Administrative Salaries (per quarter) Rent Expense (per quarter) Depreciation Expense (per quarter) Shipping has been determined to be a mixed cost with the following total costs and units: 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2023 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Cost $ 67,000 $ 94,000 $ 89,800 $ 92,600 $ 72,500 $80,000 $ 84,000 $ 100,000 17,000 $ 48.00 Units 12,500 21,000 13,800 20,000 13,700 14,000 14,300 22,500 $29.00 9.50€ $ 45,000 $ 27,000 $ 36,000 Required: Use the data to answer the…
Prepare a Sales Budget, Purchases Budget and Forecasted Income Statement for 2022 third quarter of Maryland Enterprises. Using the ff. data: June July August September Units to be Sold 1,000 1,250 1,500 1,350 Selling Price P190 Unit Cost P120 Beginning Inv for July 100 units Desired Ending Inventory 10% of Last month Unit Sales ling Expenses P25 per forecasted sales in units Administrative Expenses P10,000 per month
Question 1 The marketing department of HASF Corporations has submitted the following sales forecast for the upcoming fiscal year (all sales are on account) Q1 Q2 Q3 Q4 total Budgeted units sales ? 10% increase 10 % decrease 16,335 62,685 Budget selling price per unit 18 18 18 ? 18 budgeted sales revenue ? 297,000 ? 294,030 ? Other information Each quarter ending finished goods inventory is 20% of next month units sold. Next year first quarter beginning inventory is 3,000. Each finished units require 3 grams of raw material that cost Rs 3 per unit. Management desired to end each quarter with an inventory of raw material equal to 15% of the current quarter production needs Beginning inventory of raw material in first quarter 3,000 grams FIND UNIT SALES of Q1 Answer format should be like : 10000 donot USE COMMA's or Currency or UNITs. Answer should be plain…
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…
Clark 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.
The followings are the budget for next financial year (1 January 2023 - 31 December 2023), indicating the average selling price and variable costs of each product category. The common fixed manufacturing overhead and the fixed non-manufacturing overhead costs are estimated to be $1,250,000 and $2,778,320 respectively. Table 1: Budget Jan - Dec 2023 Sales Quantity (in units) In $ Unit selling price Unit production cost Unit selling & admin variable costs (5% of selling price) In $ Revenue Variable Production Costs Selling & Admin Variable Costs Model 1 8,400 600 250 30 Folding Bike Model 2 7,500 400 180 20 Model 3 3,500 480 200 24 Electric Bike 800 2,000 850 100 Total 20,200 5,040,000 3,000,000 1,680,000 1,600,000 11,320,000 (2,100,000)| (1,350,000)| (700,000)| (680,000)| (4,830,000) (252,000) (150,000) (84,000) (80,000) (566,000) Q1. Based on the above budgeted information, calculate the expected breakeven units for the Model 2 folding bikes.
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
Lane Products manufactures a popular kitchen utensil. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It opened negotiations with the local bank for a one-month loan of $44,000 starting March 1. The bank would charge interest at the rate of 0.5 percent per month and require the company to repay interest and principal on March 31. In considering the loan, the bank requested a projected income statement and cash budget for March. The following information is available: ● ● ● ● The company budgeted sales at 14,000 units per month in February, April, and May and at 11,000 units in March. The selling price is $62 per unit. The company offers a 2 percent discount for cash sales. The company's experience is that bad debts average 1 percent of credit sales. The inventory of finished goods on February 1 was 2,600 units. The desired finished goods inventory at the end of each month equals 25 percent of sales anticipated for the…
Current Attempt in Progress Monty Company combines its operating expenses for budget purposes in a selling and administrative expense budget For the first quarter of 2022, the following data are developed L Sales: 21,500 units unit selling price 2 Variable costs per sales dollar Sales commissions Delivery expense 3 Advertising Fixed costs per quarter Sales salaries Office salaries Depreciation Insurance Utilities $30 Save for Later 6% 4% $24,400 19,500 5,000 2,100 1,000 Prepare a selling and administrative expense budget for the first quarter of 2022 (List variable costs before fixed costs) MONTYCOMPANY Selling and Administrative Expense Budget
The Management Accountant of Kafululu Plc has prepared the following budget information for theyear ending 31st December 2022 for product A. Annual Fixed Costs K270,000.00 Variable costs per unit K90.00 Contribution to sales ratio(C/S) 75% Annual budget units 1,500 Required:a) Calculate the contribution per unit for Product A. b) Calculate the Unit Selling Price for Product A. c) Calculate the Break Even Point for Product A. d) Calculate the margin of safety in Units and in percentage terms. e) If the Selling Price per Unit is reduced by 10%, variable cost per Unit is increased to K100.00and Fixed costs remain unchanged, calculate:i. The new Breakeven Point. ii. The total units that should be sold in order to make a profit of K450,000 in 2020.(
Prepare a sales budget. Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by quarters for the year ending December 31, 2019. Palermo Company Sales Budget For the Year Ending December 31, 2019 Description Q1 Q2 Q3 Q4 Year Estimates sales Sales price x unit Sales Revenue 2. Prepare a production budget for 2 quarters. Sales budget data for Palermo Company are given in exercise 1. 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 2019. Palermo Company Direct Labor Budget For the Six Months Ending June 30, 2019…