**Brief Exercise 9-22: Preparing a Production Budget**Patrick Inc. makes industrial solvents. In the first four months of the coming year, Patrick expects the following unit sales:- January: 41,000- February: 38,000- March: 50,000- April: 51,000Patrick’s policy is to have 25% of the next month’s sales in ending inventory. On January 1, it is expected that there will be 6,700 drums of solvent on hand.**Required:**Prepare a production budget for the first quarter of the year. Show the number of drums that should be produced each month as well as for the quarter in total.

Solution:- Production budget that determines the quantity of the firm's product that required to be produced during a budgetary time period. The following formula used Production budget = Budgeted sales units + Desired ending inventory - Beginning inventoryPreparation of production budget for first quarter as follows:- Particulars January February March 1st Quarter Total Sales 41,000 38,000 50,000 129,000 Desired ending Inventory 9,500 [38000 x 25%] 12,500 [50000 x 25%] 12,750 [51000 x 25%] 12,750 Total needs 50,500 50,500 62,750 141,750 Less:- Beginning Inventory 6,700 9,500 12,500 6,700 Units to be produced 43,800 41,000 50,250 135,050 If you are satisfied.. Support me .. Thank you...

Answered: Required: Prepare a production budget…

Business

Accounting

Required: Prepare a production budget for the first quarter of the year. Show the number of drums that should be produced each month as well as for the quarter in total.

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

How does the budgeting process translate long-term goals into operating objectives? Suppose Framecraft has an Information Processing Division that provides database management services for the professional photographers and artists who buy its frames. The division uses state-of-the-art equipment and employs five information specialists. Each specialist works an average of 160 hours a month. The division’s controller has com piled the following information: Actual Data for Past Year Forecasted Data for This Year November December January February March Client billings (sales) $25,000 $35,000 $25,000 $20,000 $40,000 Selling and administrative expenses 12,000 13,000 12,000 11,000 12,500 Operating supplies 2,500 3,500 2,500 2,500 4,000 Processing overhead 3,200 3,500 3,000 2,500 3,500 Of the client billings, 60 percent are cash sales collected during the month of sale, 30 per cent are collected in the first month following the sale, and 10 percent are collected in the second month…
Create a budget for the following project: Blazer Company plans on purchasing new equipment to retool its manufacturing process. The project will involve the acquisition of equipment, installation of the new equipment, selling off the old equipment and training the workforce on the new equipment and processes. Blazer expects this project to take two years from beginning to end. Costs and expected income for the project are as shown below. Your task is to create a two-year cash budget for the project and compute a return on investment (ROI) for the project. You may ignore the time value of money in your calculation. You may make reasonable assumptions to complete this problem so long as you document them. Facts: a. The equipment to be purchased will cost $455,000. The equipment will be purchased and paid for at the beginning of Year 1. b. Installation cost will be $55,000. c. Blazer will purchase a maintenance contract for the equipment. The first year of maintenance is included in the…
Prepare the direct material budgets for the upcoming five years. The budgets should also include a schedule of expected cash disbursements for purchase of materials, by year and in total. Make your assumptions about the safety stock of materials and the timing of payments clear. Total Raw materials $23 ( Distilled water $2, Rose oil $2, Sandalwood $2, Cedar $2, Musk $8, vanilla $5, Ethyl $1, Methyl $1) Box $10 Bottle $20 Labour $7
Reham Co is preparing its direct labor budget for 2020 from the following production budget based on a calendar year. Quarter Units 1 20,000 2 25,000 3 35,000 4 30,000 Each unit requires 1.5 hours of direct labor. Wage rates are expected to be OMR16 for the first 2 quarters and OMR18for quarters 3 and 4. What is the Budgeted Total Direct Labor Cost for Quarter 4
A project ABC is planned for 15 months with a budget (BAC) of USD 150,000. If the scheduled percent of work completed after three months is 20% and the actual work completion is 15%, Find the schedule variance and schedule performance index also conclude the project status that you will identify after calculating SV and SVI.
Assuming your budgets are stable across the year, how much of your Company's budget do you have left for developing new collateral for the remainder of this month?
You are a Maintenance Manager at a new facility without any prior records. How would you go about developing a budget for the coming year?
Whispering Winds Company estimates that unit sales will be 10,500 in quarter 1; 12,600 in quarter 2; 13,800 in quarter 3; and 17,800 in quarter 4. Management wants to have an ending finished goods inventory equal to 21% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first six months of 2022. WHISPERING WINDS COMPANY Production Budget For the Six Months Ending June 30, 2022 Quarter 1 2 Total
The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below: Month July August September October November December January February March April May June July Total Average Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Administrative Costs $ 130, 151 Regression Residual Total 83,293 226,090 216,734 258,433 185,299 219,817 245, 510 209,802 192,095 250,828 171,098 128,677 $ 2,517,827 $ 193,679 SUMMARY OUTPUT Regression Statistics The controller's office has analyzed the data and has given you the results from the regression analysis: Credit Hours df 1 11 12 1,100 557 1,834 1,442 1,751 1,554 1,781 1,815 1,506 1,565 1,802 862 757 18,326 1,410 0.9169697 0.840833374 0.826363681 22,082.14006 13 SS…
Which Schedule must the taxpayer use to claim a payment made for alimony? Multiple Choice Schedule 1. Schedule 2. Schedule 3. The taxpayer does not need to use a Schedule.
Fill in the missing cells in the following cash budget. Interpret the values for NCF and the ending cash position. Develop a cash budget for the next two months using the following information: Monthly sales forecasts are $210,000 and $30,000 for the next two months Sales in the current month were $140,000 80 percent of sales are collected in the month of sale, with the remainder collected in the following month Cost of goods sold equal 70 percent o sales The monthly lease payment is $75,000 The cash position at the end of the current month is $70,000 The target cash balance is $40,000
A local piano distributor is preparing its February purchase budget for pianos and provides the following information: • Budgeted Sales, January: 210 pianos • Budgeted Sales, February: 170 pianos • Budgeted Sales, March: 250 pianos If the distributor always wants to have 20% of the pianos they will need for the next month's sales on hand at the end of each month, how many pianos do they need to purchase in February?