Förecast Sales volume andBudgetFor 20Y8, Raphael Frame Company prepared the sales budget that follows.At the end of December 20Y8, the following unit sales data were reported for the year:Unit Sales8" x 10"12" x 16"FrameFrameEast20,39415,496Central5,3536,272West4,8505,304Raphael Frame CompanySales BudgetFor the Year Ending December 31, 20Y8UnitUnit SalesProduct and AreaSellingTotal SalesVolumePrice8" x 10" Frame:East19,800$31$613,800Central5,30031164,300West5,00031155,000.Total30,100$933,10012" x 16" Frame:East14,900$32$476,800Central6,40032204,800West5,20032166,400Total26.500$848.000 Total revenue from sales$1,781,100For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending December 31, 20Y8. The unit selling price forthe 8" x 10" frame is expected to increase to $32 and the unit selling price for the 12" x 16" frame is expected to increase to $34, effective January 1, 20Y9.Required:1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y8, over budget. Use the minus sign to indicate a decrease in amountand percent. Round percents to the nearest whole percent.Unit Sales,Increase (Decrease)Year Ended 20Y8Actual Over BudgetBudgetActual SalesAmountPercent8" x 10" Frame:East%Central%West%12" x 16" Frame:East%CentralWest2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to be used forpreparing the sales budget for the year ending December 31, 20Y9. Use the minus sign to indicate a decrease in percent. Round budgeted units to the nearestwhole unit.20Y8Percentage20Y9ActualIncreaseBudgetedUnits(Decrease)Units (rounded)8" x 10" Frame:East%

1) 8"x10" frame: Budget sales (units) Actual sales (units) Increase / (Decrease) units Increase…

For 20Y8, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales 8" x 10" 12" x 16" Frame Frame East 20,394 15,496 Central 5,353 6,272 West 4,850 5,304 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Unit Unit Sales Product and Area Selling Total Sales Volume Price 8" x 10" Frame: East 19,800 $31 $613,800 Central 5,300 31 164,300 West 5,000 31 155,000. Total 30,100 $933,100 12" x 16" Frame: East 14,900 $32 $476,800 Central 6,400 32 204,800 West 5,200 32 166,400 Total 26.500 $848.000

For 20Y8, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales 8" x 10" 12" x 16" Frame Frame East 20,394 15,496 Central 5,353 6,272 West 4,850 5,304 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y8 Unit Unit Sales Product and Area Selling Total Sales Volume Price 8" x 10" Frame: East 19,800 $31 $613,800 Central 5,300 31 164,300 West 5,000 31 155,000. Total 30,100 $933,100 12" x 16" Frame: East 14,900 $32 $476,800 Central 6,400 32 204,800 West 5,200 32 166,400 Total 26.500 $848.000

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

The following budgeted production and sales information is for Flushing Company for the month of December: Product XXX Product ZZZ Estimated beginning inventory 28,200 units 19,800 units Desired ending inventory 35,000 units 15,300 units Region I, anticipated sales 302,000 units 253,000 units Region II, anticipated sales 196,000 units 141,000 units The unit selling price for product XXX is $7 and for product ZZZ is $15. Budgeted production for product XXX during the month is a. 504,800 units b. 498,000 units c. 533,000 units Od. 491,200 units
How do I prepare the selling and administrative expense budget for the quarter ended March 31, 20X1?
Use the information below for Flushing Company to answer the question that follow. Below is budgeted production and sales information for Flushing Company for the month of December. Product XXX Product ZZZ Estimated beginning inventory 30,500 units 20,000 units Desired ending inventory 36,500 units 14,900 units Region I, anticipated sales 329,000 units 265,000 units Region II, anticipated sales 190,000 units 148,000 units The unit selling price for product XXX is $5 and for product ZZZ is $13.Budgeted sales for the month are a.$8,812,000 b.$12,116,000 c.$4,660,000 d.$7,964,000
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
Budgeted Income Statement and Supporting Budgets The budget director of Birding Homes & Feeders Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: Estimated sales for January: Bird house 15,000 units at $25 per unit Bird feeder 40,000 units at $15 per unit Estimated inventories at January 1: Direct materials: Wood 600 ft. Plastic 1,000 lbs. Finished products: Bird house 1,000 units at $15 per unit Bird feeder 2,500 units at $8 per unit Desired inventories at January 31: Direct materials: Wood 500 ft. Plastic 1,250 lbs. Finished products: Bird house 1,500 units at $15 per unit Bird feeder 3,000 units at $8 per unit Direct materials used in production: In manufacture of Bird House: Wood 0.80 ft. per unit of product Plastic 0.10 lb. per unit of product In manufacture of Bird Feeder: Wood 0.20…
Budgeted Income Statement and Supporting Budgets The budget director of Birding Homes & Feeders Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: Estimated sales for January: Bird house 15,000 units at $25 per unit Bird feeder 40,000 units at $15 per unit Estimated inventories at January 1: Direct materials: Wood 600 ft. Plastic 1,000 lbs. Finished products: Bird house 1,000 units at $15 per unit Bird feeder 2,500 units at $8 per unit Desired inventories at January 31: Direct materials: Wood 500 ft. Plastic 1,250 lbs. Finished products: Bird house 1,500 units at $15 per unit Bird feeder 3,000 units at $8 per unit Direct materials used in production: In manufacture of Bird House: Wood 0.80 ft. per unit of product Plastic 0.10 lb. per unit of product In manufacture of Bird Feeder: Wood 0.20…
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: Rumble Thunder Estimated inventory (units), June 1 Desired inventory (units), June 30 Expected sales volume (units): Midwest Region South Region Unit sales price a. Prepare sales budget. Midwest Region South Region Total Model: Thunder Sonic Inc. Sales Budget For the Month Ending June 30 Product and Area Unit Sales Volume Unit Selling Price Total Sales Model: Rumble Midwest Region South Region Total Total revenue from sales 750 500 10001000 12,000 14,000 $60 300 250 3,500 4,000 $90 000 0000
Vibrant 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: Rumble Thunder Estimated inventory (units), June 1 258 70 Desired inventory (units), June 30 296 61 Expected sales volume (units): North Region 3,250 3,650 South Region 5,200 4,500 Unit sales price $95 $185 a. Prepare a sales budget. Vibrant Inc. Sales Budget For the Month Ending June 30 Unit Unit Total Sales Selling Sales Volume Price Product and Area Model Rumble: North Region South Region Total Model Thunder: North Region South Region Total Total revenue from sales b. Prepare a production budget. Vibrant Inc. Production Budget For the Month Ending June 30 Units Units Model Model Rumble Thunder Expected units to be sold Total units required Total units to be produced
E9-3A Budget Preparation Westport Company is preparing its master budget for May. Use the estimates provided to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.) a. What should total sales revenue be if territories E and W estimate sales of 50,000 and 100,000 units, respectively, and the unit selling price is $30? b. If the beginning finished goods inventory is an estimated 6,000 units and the desired ending inventory is 7,000 units, how many units should be produced? c. What dollar amount of materials should be purchased at $2 per pound if each unit of product requires 2.5 pounds and beginning and ending materials inventories should be 12,000 and 13,500 pounds, respectively? d. How much direct labor cost should be incurred if each unit produced requires 0.5 hours at an…
A merchandiser, provides the following information for its December budgeting process: November 30 inventory 1,620 units Budgeted sales for December 4,050 units Desired December 31 inventory 2,835 units Budgeted purchases in December are: