1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y6, over budget. Use the minus sign to indicate a decrease in amount and percent. Round percents to the nearest whole percent.Unit Sales,Increase (Decrease)Year Ended 20Y6Actual Over BudgetBudgetActual SalesAmountPercent8" x 10" Frame:East%CentralWest%12" x 16" Frame:East%Central%West%2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y7, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y7. Use the minus sign to indicate a decrease in percent. Round budgeted units to the nearest whole unit.20Y6Percentage20Y7ActualIncreaseBudgetedUnits(Decrease)Units (rounded)8" x 10" Frame:East%Central%West%12" x 16" Frame:East%Central%West%3. Prepare a sales budget for the year ending December 31, 20Y7.Raphael Frame CompanySales BudgetFor the Year Ending December 31, 20Y7Product and AreaUnit Sales VolumeUnit Selling PriceTotal Sales8" x 10" Frame:EastCentralWestTotal12" x 16" Frame:EastCentralWestTotalTotal revenue from sales For 20Y6, Raphael Frame Company prepared the sales budget that follows.At the end of December 20Y6, the following unit sales data were reported for the year:Unit Sales8" x 10"12" x 16"FrameFrameEast24,44014,910Central6,2224,018West5,4323,060Raphael Frame CompanySales BudgetFor the Year Ending December 31, 20Y6UnitUnit SalesSellingProduct and AreaVolumePriceTotal Sales8" x 10" Frame:East23,500$24$564,000Central6,10024146,400West5,60024134,400Total35,200$844,80012" x 16" Frame:East14,200$34$482,800Central4,10034139,400West3,00034102,000Total21,300$724,200Total revenue from sales$1,569,000

1. Unit Sales,Year Ended 20Y6 Increase (Decrease)Actual Over Budget Budget Actual Sales…

Unit Sales, actual sales to budoet indicated in ne (1) is to continue Inits (rounded s budget for the year ending December Sales Budeet For the Year Ending December 31, 20Y7 Unit Sales Volume Unit Selling Price Total Sales

Unit Sales, actual sales to budoet indicated in ne (1) is to continue Inits (rounded s budget for the year ending December Sales Budeet For the Year Ending December 31, 20Y7 Unit Sales Volume Unit Selling Price Total Sales

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

budget the labor expense for a forecasted sales level of $200,000 from the following data :historical sales level $100,000 Historical semi variable $30,000(tc $30,000=vc$25,000+$5,000)
Thank you.
Please do not give solution in image format thanku
Need detail explanation Q. Find the breakeven point and provide the income statement at break even. ** attached image
Please do not give solution in image format thanku
Subject- accounting
Prepare the operating budgetand necessary schedule for the 3rd quarter8. Selling and Administrative Expense Budget
Based on the following production and sales data of Frixion Co. for March of the current year: Product T Product X Estimated inventory, March 1 28,000 units 20,000 units Desired inventory, March 31 32,000 units 15,000 units Expected sales volume: Area I 320,000 units 260,000 units Area II 190,000 units 130,000 units Unit sales price $6 $14 Question Content Area a. Prepare a sales budget. Frixion Co.Sales BudgetFor the Month Ending March 31 Product and Area Unit Sales Volume Unit Selling Price Total Sales Product T: Area I fill in the blank ca0b7bf7b025f99_1 $fill in the blank ca0b7bf7b025f99_2 $fill in the blank ca0b7bf7b025f99_3 Area II fill in the blank ca0b7bf7b025f99_4 $fill in the blank ca0b7bf7b025f99_5 fill in the blank ca0b7bf7b025f99_6 Total fill in the blank ca0b7bf7b025f99_7 $fill in the blank ca0b7bf7b025f99_8 Product X: Area I fill in the blank ca0b7bf7b025f99_9 $fill in the blank ca0b7bf7b025f99_10…
Production and sales estimates for March for Robin Co. are as follows: Estimated inventory ( units), March 117,100 Desired inventory (units), March 31 19,700 Expected sales volume ( units): Area M 6,500 Area L 9,300 Area O 7, 100 Unit sales price $17 Budgeted production for March is a. 42, 600 b. 22,900 c. 59,700 d. 25,500
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…
The management of Zigby Manufacturing prepared the following balance sheet for March 31. Assets ZIGBY MANUFACTURING Balance Sheet March 31 Liabilities and Equity Cash Accounts receivable Raw materials inventory Finished goods inventory Equipment Less: Accumulated depreciation $ 1,680,000 420,000 Total assets $ 112,000 964,320 275,800 Liabilities Accounts payable Loan payable 911,512 Long-term note payable Equity 1,260,000 Common stock Retained earnings $ 3,523,632 Total liabilities and equity To prepare a master budget for April, May, and June, management gathers the following information. $ 562,800 12,000 1,400,000 938,000 610,832 $ 1,974,800 1,548,832 $ 3,523,632 a. Sales for March total 57,400 units. Budgeted sales in units follow: April, 57,400; May, 54,600; June, 56,000; and July, 57,400. The product's selling price is $24.00 per unit and its total product cost is $19.85 per unit. b. Raw materials inventory consists solely of direct materials that cost $20 per pound. Company…
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