5 1. Prepare a production budget for the upcoming year for the months of January,February, March and April.Production BudgetJanuaryFebruaryMarchApril45,00075,000Budgeted salesAdd: Ending inventory55,00040,000Total needsDeduct: Beginning inventoryRequired production3. Prepare a direct materials budget showing the quantity of material to be purchasedfor January, February, March and for the quarter in total.Direct Materials BudgetJanuaryFebruaryMarchFirst QuarterProduction needs (Ibs)Add: Ending inventoryTotal Material needsDeduct: Beginning inventoryMaterial purchases The following information relates to a company that produces a single product.Each unit requires five pounds of material. Inventory requirements are as follows:a.The finished goods inventory on hand at the end of each month must be equal to8,000 units plus 33% of the next month's sales. The finished goods inventory onDecember 31 is budgeted based on this requirement.b.The raw materials inventory on hand at the end of each month must be equal to one-half of the following month's production needs for raw materials. The raw materialsinventory on December 31 is budgeted based on this requirement.c. The company maintains no work in process inventories.A sales budget for the company for the first and second quarters of the upcoming yearfollows.Budgeted Salesin Units45,00055,00075,00040,00025,00015,000JanuaryFebruaryMarchAprilMayJuneRequired:1. Prepare a production budget for the upcoming year for the months of January,February, March and April.Production BudgetJanuaryFebruaryMarchAprilBudgeted salesAdd: Ending inventory45,00055,00075,00040,000'M

The production budget is a detailed plan that outlines the number of products that a company plans…

Prepare a productio budget for the upcoming year for the months of January, February, March and April. Production Budget January February March April Budgeted sales Add: Ending inventory Total needs Deduct: Beginning inventory Required production 45,000 55,000 75,000 40,000 3. Prepare a direct materials budget showing the quantity of material to be purchased for January, February, March and for the quarter in total. Direct Materials Budget January February March First Quarter Production needs (lbs) Add: Ending inventory Total Material needs Deduct: Beginning inventory Material purchases

Prepare a productio budget for the upcoming year for the months of January, February, March and April. Production Budget January February March April Budgeted sales Add: Ending inventory Total needs Deduct: Beginning inventory Required production 45,000 55,000 75,000 40,000 3. Prepare a direct materials budget showing the quantity of material to be purchased for January, February, March and for the quarter in total. Direct Materials Budget January February March First Quarter Production needs (lbs) Add: Ending inventory Total Material needs Deduct: Beginning inventory Material purchases

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 13CE: Nashler Company has the following budgeted variable costs per unit produced: Budgeted fixed overhead...

See similar textbooks

Similar questions

Lens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Â Prepare a sales budget, production budget. direct materials budget for silicon and solution, and a direct labor budget.
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.
Rehydrator makes a nutrition additive and expects to sell 3,000 units in January, 2,000 in February, 2,500 in March, 2,700 in April. and 2,900 in May. The required ending inventory is 20% of the next months sales, and the beginning inventory on January 1 was 600 units. Prepare a production budget for the first four months of the year.
Eastman, Inc., manufactures and sells three products: R, S, and T. In January, Eastman, Inc., budgeted sales of the following. At the end of the year, actual sales revenue for Product R and Product S was 3,075,000 and 3,254,000, respectively. The actual price charged for Product R was 25 and for Product S was 20. Only 10 was charged for Product T to encourage more consumers to buy it, and actual sales revenue equaled 540,000 for this product. Required: 1. Calculate the sales price and sales volume variances for each of the three products based on the original budget. 2. Suppose that Product T is a new product just introduced during the year. What pricing strategy is Eastman, Inc., following for this product?
Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
Lens & Shades sells sunglasses for $37 each and is estimating sales of 21,000 units in January and 19,000 in February. Each lens consist of 2.00 mm of plastic costing $2.50 per mm, 1.7 oz of dye costing $2.80 per ounce. and 0.50 hours direct labor at a labor rate of $18 per unit. Desired inventory levels are: Prepare a sales budget, production budget, direct materials budget for silicon and solution, and a direct labor budget.
Salisbury Bottle Company manufactures plastic two-liter bottles for the beverage industry. The cost standards per 100 two-liter bottles are as follows: At the beginning of March, Salisburys management planned to produce 500,000 bottles. The actual number of bottles produced for March was 525,000 bottles. The actual costs for March of the current year were as follows: a. Prepare the March manufacturing standard cost budget (direct labor, direct materials, and factory overhead) for Salisbury, assuming planned production. b. Prepare a budget performance report for manufacturing costs, showing the total cost variances for direct materials, direct labor, and factory overhead for March. c. Interpret the budget performance report.
TIB makes custom guitars and prepared the following sales budget for the second quarter It also has this additional information related to its expenses: Direct material per unit $55, Direct labor per hour 20, Variable manufacturing overhead per hour 3.50, Fixed manufacturing overhead per month 3,000, Sales commissions per unit 20, Sales salaries per month 5,000, Delivery expense per unit 0.50, Utilities per month 4,000. Administrative salaries per month 20,000, Marketing expenses per month 8,000, Insurance expense per month 11,000, Depreciation expense per month 9,000. Prepare a sales and administrative expense budget for each month in the quarter ended June 30. 2018.
The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is 25 per unit. The desired ending inventory on June 30 is 2,000 units, and the expected beginning inventory on June 1 is 3,000 units. Prepare the following: a. A sales budget for June. b. A production budget for June.
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.
Nashler Company has the following budgeted variable costs per unit produced: Budgeted fixed overhead costs per month include supervision of 98,000, depreciation of 76,000, and other overhead of 245,000. Required: 1. Prepare a flexible budget for all costs of production for the following levels of production: 160,000 units, 170,000 units, and 175,000 units. 2. What is the per-unit total product cost for each of the production levels from Requirement 1? (Round each unit cost to the nearest cent.) 3. What if Nashler Companys cost of maintenance rose to 0.22 per unit? How would that affect the unit product costs calculated in Requirement 2?