Production budget help please Exercise 23.3 (Algo) Production Budgets (LO23-4, LO23-5)NuFloor Manufacturing produces floor tiles. The managers at NuFloor are trying to develop budgets for the upcoming quarter. Thefollowing data have been gathered for a particular tile design.Projected unit salesSelling price per caseInventory at the beginning of the quarterTarget inventory at the end of the quarterDirect labor hours needed to produce one caseDirect labor wagesDirect material cost per caseVariable manufacturing overhead cost per caseFixed overhead costs for the upcoming quarter1,120 cases240150 cases100 cases2 hours10 per hour2$2$$220,0008a. Using this information, develop NuFloor's sales forecast in dollars and its schedule of production in units.b. What is NuFloor's budgeted variable manufacturing cost per case?c. Prepare NuFloor's manufacturing cost budget.d. What is the projected ending inventory value for this particular tile design?Complete this question by entering your answers in the tabs below.Required ARequired BRequired CRequired DUsing this information, develop NuFloor's sales forecast in dollars and its schedule of production in units.Budgeted sales (in dollars)Planned production (cases)2 of 3Next >Prev a. Using this information, develop NuFloor's sales forecast in dollars and its schedule of production in units.b. What is NuFloor's budgeted variable manufacturing cost per case?c. Prepare NuFloor's manufacturing cost budget.d. What is the projected ending inventory value for this particular tile design?Complete this question by entering your answers in the tabs below.kRequired ARequired BRequired CRequired DcesPrepare NuFloor's manufacturing cost budget. (Round your cost per unit answer to 2 decimal places.)Variable manufacturing costs:Total variable manufacturing costsTotal cost of finished goods manufactured< Required BRequired D >

Solution a: Budgeted sales (In dollars) = Budgeted sales units * Selling price per unit = 1120*$240…

NuFloor Manufacturing produces floor tiles. The managers at NuFloor are trying to develop budgets for the upcoming quarter. The following data have been gathered for a particular tile design. Projected unit sales Selling price per case Inventory at the beginning of the quarter Target inventory at the end of the quarter Direct labor hours needed to produce one case Direct labor wages Direct material cost per case Variable manufacturing overhead cost per case Fixed overhead costs for the upcoming quarter 1,120 cases 240 150 cases 100 cases 2 hours $ %24 10 per hour 6. $220,000 a. Using this information, develop NuFloor's sales forecast in dollars and its schedule of production in units. 5. What is NuFloor's budgeted variable manufacturing cost per case? E. Prepare NuFloor's manufacturing cost budget. d. What is the projected ending inventory value for this particular tile design?

NuFloor Manufacturing produces floor tiles. The managers at NuFloor are trying to develop budgets for the upcoming quarter. The following data have been gathered for a particular tile design. Projected unit sales Selling price per case Inventory at the beginning of the quarter Target inventory at the end of the quarter Direct labor hours needed to produce one case Direct labor wages Direct material cost per case Variable manufacturing overhead cost per case Fixed overhead costs for the upcoming quarter 1,120 cases 240 150 cases 100 cases 2 hours $ %24 10 per hour 6. $220,000 a. Using this information, develop NuFloor's sales forecast in dollars and its schedule of production in units. 5. What is NuFloor's budgeted variable manufacturing cost per case? E. Prepare NuFloor's manufacturing cost budget. d. What is the projected ending inventory value for this particular tile design?

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 63E: Use the following information for Exercises 9-63 and 9-64: Palladium Inc. produces a variety of...

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.
Use the following information for Exercises 9-50 and 9-51: 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 5 quarters are as follows: The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Exercise 9-50 Sales Budget Refer to the information regarding Stillwater Designs above. Required: 1. Prepare a sales budget for each quarter of 20X1 and for the year in total. Show sales by product and in total for each time period. 2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?
Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: a. Finished goods inventory on January 1 is 32,000 units, each costing 166.06. The desired ending inventory for each month is 80% of the next months sales. b. The data on materials used are as follows: Inventory policy dictates that sufficient materials be on hand at the end of the month to produce 50% of the next months production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is 3 hours. The average direct labor cost per hour is 14.25. d. Overhead each month is estimated using a flexible budget formula. (Note: Activity is measured in direct labor hours.) e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Note: Activity is measured in units sold.) f. The unit selling price of the subassembly is 205. g. All sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of the quarter, as is the interest due (cash borrowed at the end of the quarter is repaid at the end of the following quarter). The interest rate is 12% per annum. No money is owed at the beginning of January. Required: 1. Prepare a monthly operating budget for the first quarter with the following schedules. (Note: Assume that there is no change in work-in-process inventories.) a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Selling and administrative expenses budget g. Ending finished goods inventory budget h. Cost of goods sold budget i. Budgeted income statement j. Cash budget 2. CONCEPTUAL CONNECTION Form a group with two or three other students. Locate a manufacturing plant in your community that has headquarters elsewhere. Interview the controller for the plant regarding the master budgeting process. Ask when the process starts each year, what schedules and budgets are prepared at the plant level, how the controller forecasts the amounts, and how those schedules and budgets fit in with the overall corporate budget. Is the budgetary process participative? Also, find out how budgets are used for performance analysis. Write a summary of the interview.
Play-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.
Use the following information for Exercises 9-63 and 9-64: Palladium Inc. produces a variety of household cleaning products. Palladiums controller has developed standard costs for the following four overhead items: Next year, Palladium expects production to require 90,000 direct labor hours. Exercise 9-63 Flexible Budget for Various Levels of Activity Refer to the information for Palladium Inc. above. Required: 1. Prepare an overhead budget for the expected level of direct labor hours for the coming year. 2. Prepare an overhead budget that reflects production that is 15% higher than expected and for production that is 15% lower than expected.
Sunrise Poles manufactures hiking poles and is planning on producing 4,000 units in March and 3,700 in April. Each pole requires a half pound of material, which costs $1.20 per pound. The companys policy is to have enough material on hand to equal 10% of the next months production needs and to maintain a finished goods inventory equal to 25% of the next months production needs. What is the budgeted cost of purchases for March?
Preparing a performance report Use the flexible budget prepared in P7-6 for the 31,000-unit level and the actual operating results listed below for the 31,000-unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 31,000 units differs from the master budget operating income at 30,000 units in Figure 7-12. 3. Given the level at which the company operated, how was its cost control? Item Direct materials: Direct labor:
NuFloor Manufacturing produces floor tiles. The managers at NuFloor are trying to develop budgets for the upcoming quarter. The following data have been gathered for a particular tile design. Projected unit sales Selling price per case Inventory at the beginning of the quarter Target inventory at the end of the quarter Direct labor hours needed to produce one case Direct labor wages Direct material cost per case Variable manufacturing overhead cost per case Fixed overhead costs for the upcoming quarter 3,600 cases 200 600 cases 800 cases 0.40 hours 15 per hour 16 2$ $ $319,200 10 a. Using this information, develop NuFloor's sales forecast in dollars and its schedule of production in units. b. What is NuFloor's budgeted variable manufacturing cost per case? c. Prepare NuFloor's manufacturing cost budget. d. What is the projected ending inventory value for this particular tile design? Complete this question by entering your answers in the tabs below. Required A Required B Required C…
Your company manufactures tabies and chairs In your role as a manager you are responsible for the budget preparalion for the quarter ending 30 March 2018 Tho quartor consists of 13 weeks The other managers are inexpenenced, and you decided to do the budget on your own You have accumuiated the following data for the quarter Finished product Tables Chairs Forecasted sales (unts) 5,525 11,050 Seling Price per unit R242 50 R152 00 Inventory opening balance (unta) 450 700 Closing Inventory Tables closing inventory must equal 1 week's sales units Chairs closing inventory must equal 2 week's sales units Raw Materials: Wood Metal Tables (meters per unit) 8m 1m Chairs (meters per unit) 3m O 50m Cost per meter R135 00 R150 00 Opening nventory (meters) 2,000m 750m Closing nventory Wood closing stock must equal 1 week's producton requirement Metal closing stock must equal 1 week's production requirement Required Prepare the following budgets 1 Production budget (Units) 2 Direct material usage…
Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Laghari Company makes and sells high-quality glare filters for microcomputer monitors. John Tanaka, controller, is responsible for preparing Laghari's master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employer's share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the company's union contract calls for an increase in direct labor wages that is included in the direct labor rate. Laghari expects to have 5,600 glare filters in inventory on December 31 of the current year, and has a policy of carrying 35 percent of the following month's projected sales in inventory. Information on the first four months of the coming year is as follows: January February March April Estimated unit sales 36,000 34,500 39,000 38,600 Sales price per unit $80 $80 $75 $75…
Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Greiner Company makes and sells high-quality glare filters for microcomputer monitors. John Craven, controller, is responsible for preparing Greiner’s master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employer’s share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the company’s union contract calls for an increase in direct labor wages that is included in the direct labor rate. Greiner expects to have 5,600 glare filters in inventory on December 31 of the current year, and has a policy of carrying 25 percent of the following month’s projected sales in inventory. Information on the first four months of the coming year is as follows: January February March April Estimated unit sales 35,600 34,600 40,400 39,600 Sales price per unit $80 $80 $76 $76…