Please do not give solution in image format thanku On January 1, 2020, the Rokking Company budgeted the following for the year ended December 31, 2020:1.Sales units: First quarter 5,600; second quarter 6,600; third quarter 7,700; fourth quarter 8,300 units; First andsecond quarters of 2021: 8,700 units.Ending raw materials inventory: 40% of the next quarter's production requirements.3.Ending finished goods inventory: 30% of the next quarter's expected sales in units.4. Desired production for first quarter of 2021 is 8,700 units.2.3 kilograms of raw materials are needed to make each unit of finished goods. Raw materials purchased are expected tocost $3 per kilogram.Prepare a production budget and a direct materials budget by quarters for the year ended December 31, 2020.

The production budget is prepared to estimate the number of units to be produced during the period.…

On January 1, 2020, the Rokking Company budgeted the following for the year ended December 31, 2020: 1. Sales units: First quarter 5,600; second quarter 6,600; third quarter 7,700; fourth quarter 8,300 units; First and second quarters of 2021: 8,700 units. Ending raw materials inventory: 40% of the next quarter's production requirements. Ending finished goods inventory: 30% of the next quarter's expected sales in units. Desired production for first quarter of 2021 is 8,700 units. 2. 3. 4. 3 kilograms of raw materials are needed to make each unit of finished goods. Raw materials purchased are expected to cost $3 per kilogram. Prepare a production budget and a direct materials budget by quarters for the year ended December 31, 2020.

On January 1, 2020, the Rokking Company budgeted the following for the year ended December 31, 2020: 1. Sales units: First quarter 5,600; second quarter 6,600; third quarter 7,700; fourth quarter 8,300 units; First and second quarters of 2021: 8,700 units. Ending raw materials inventory: 40% of the next quarter's production requirements. Ending finished goods inventory: 30% of the next quarter's expected sales in units. Desired production for first quarter of 2021 is 8,700 units. 2. 3. 4. 3 kilograms of raw materials are needed to make each unit of finished goods. Raw materials purchased are expected to cost $3 per kilogram. Prepare a production budget and a direct materials budget by quarters for the year ended December 31, 2020.

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 15E: Palmgren Company produces consumer products. The sales budget for four months of the year is...

See similar textbooks

Similar questions

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.
A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent inflation rate. Listed below are selected items from next years budget before the adjustment. After adjusting for the 3 percent inflation rate, what is the companys total budget for the selected items before taxes for next year? a. 858,150 b. 860,412 c. 810,971 d. 858,971
CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
Roman Inc. has the following totals from its operating budgets: Prepare a budgeted income statement for the year ended December 31, 2016, assuming that income from operations is taxed at a rate of 30%.
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,000; second quarter 6,900; third quarter 7,300. Ending raw materials inventory: 40% of the next quarter’s production requirements. Ending finished goods inventory: 25% of the next quarter’s expected sales units. Third-quarter production: 7,360 units. The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to production and sales that occur in 2020. 3 pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $6 per pound. (A) Prepare a production budget by quarters for the 6-month period ended June 30, 2020. HARDIN COMPANYProduction Budget For the Six Months Ending June 30, 2020June 30, 2020For…
On January 1, 2020, the Ivanhoe Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 6,000; second quarter 6,900; third quarter 7,400. Ending raw materials inventory: 40% of the next quarter’s production requirements. Ending finished goods inventory: 25% of the next quarter’s expected sales units. Third-quarter production: 7,840 units. The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to production and sales that occur in 2020. 4 pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $5 per pound.
On January 1, 2020, the Carla Vista Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,400; second quarter 6,100; third quarter 7,900. Ending raw materials inventory: 40% of the next quarter’s production requirements. Ending finished goods inventory: 25% of the next quarter’s expected sales units. Third-quarter production: 7,430 units. The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to production and sales that occur in 2020. 5 pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $6 per pound. A) Prepare a production budget by quarters for the 6-month period ended June 30, 2020. B) Prepare a direct materials budget by quarters for the 6-month period ended June 30, 2020.
On January 1, 2020, the Hassan Engineering Co has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,000; second quarter 6,000; third quarter 7,000 Ending finished goods inventory: 30% of the next quarter’s expected sales units The ending finished goods inventories at December 31, 2019, follow the same percentage relationships to production and sales that occur in 2020. What is the budgeted production for Quarter 2?
On January 1, 2022, the Bramble Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2022. Sales units: Ending raw materials inventory: Ending finished goods inventory: Third-quarter production: First quarter 5,800; second quarter 6,960; third quarter 8,120. 40% of the next quarter's production requirements. 25% of the next quarter's expected sales units. 8,470 units. The ending raw materials and finished goods inventories at December 31, 2021, follow the same percentage relationships to production and sales that occur in 2022. Three pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $4 per pound. Prepare a production budget by quarters for the 6-month period ended June 30, 2022. BRAMBLE COMPANY Production Budget 1 Quarter 2
B) The data collected from the sales budget for the first five months of 2020 is given for a particular product of Al Salam Corporation. As below. Months January February March April May Sales Budget (Units) 11,300 14,700 16,700 18,400 13,200 Consider the following information: The inventory of finished product at the end of each month is to be equal to 25% of the sales estimated for the next month. On January1, 2020, there were 5,000 units of production on hand. No work in progress at the end of any month. Each product requires two types of materials in following quantities. Material X: 4 Units and Material Y: 5 Units. Materials equal to one half of the next month’s production are to be in hand at the end of each month. This requirement was met on January, 2010. Prepare a budget showing quantities of each type of materials to be produced each month for the first quarter of 2010.
On January 1, 2022, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2022. Sales units: Ending raw materials inventory: Ending finished goods inventory: Third-quarter production: First quarter 5,000; second quarter 6,000; third quarter 7,000. 40% of the next quarter's production requirements. 25% of the next quarter's expected sales units. 7,200 units. The ending raw materials and finished goods inventories at December 31, 2021, follow the same percentage relationships to production and sales that occur in 2022. Three pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $4 per pound. (a) Prepare a production budget by quarters for the 6-month period ended June 30, 2022.
On January 1,2022, the Vaughn Company budget committee has reached agreement on the following data for the 6 months ending June 30,2022. Sales units: First quarter 7,200: second quarter 8,640: third quarter 10,080.Ending raw materials inventory: 40% of the next quarter's production requirements.Ending finished goods inventory: 25% of the next quarter's expected sales units.Third-quarter production: 10,430 units. The ending raw materials and finished goods inventories at December 31,2021, follow the same percentage relationships to production and sales that occur in 2022. Three pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $4 per pound. Total Required DIrect Labor HoursTotal Pounds Needed for productionDirect Material PurchasesCost Per PoundDirect Labor Cost Per HourTotal Cost of Direct Material PurchasesDirect Materials Per unitUnits to be…