Meera Company is preparing its master budget for 2021. Relevant data pertaining to its production, direct materials and direct labor budgets are as follows. Production: The management has the following unit sales projections for 2021. Quarter 1 1500 2000 Quarter 2 Quarter 3 950 Quarter 4 950 Management desires to maintain the ending finished goods inventories at 30% of the next quarter's budgeted sales volume. Ending inventory of finished goods at December 31,2021, will be 320 units. Direct materials: Each unit requires 45 pounds of raw materials at a cost of OMR 15.5 per pound. Management desires to maintain raw materials inventories at 30% of the next quarter's production requirements. Assume that the ending inventory of raw material on December 31,2021 (Q4) is 1530 pounds. The estimated beginning inventory of raw material on January 1,2021(Q1) is 1490. Direct labor: Production of a single product requires 3 hours of time by employees. The employees are paid OMR 15.300 per hour. Requirements: 1. Prepare a production budget by quarters for 2021. 2. Prepare a direct materials budget by quarters for 2021. 3. Prepare a direct labor budget by quarters for 2021.

Meera Company is preparing its master budget for 2021. Relevant data pertaining to its production, direct materials and direct labor budgets are as follows. Production: The management has the following unit sales projections for 2021. Quarter 1 1500 2000 Quarter 2 Quarter 3 950 Quarter 4 950 Management desires to maintain the ending finished goods inventories at 30% of the next quarter's budgeted sales volume. Ending inventory of finished goods at December 31,2021, will be 320 units. Direct materials: Each unit requires 45 pounds of raw materials at a cost of OMR 15.5 per pound. Management desires to maintain raw materials inventories at 30% of the next quarter's production requirements. Assume that the ending inventory of raw material on December 31,2021 (Q4) is 1530 pounds. The estimated beginning inventory of raw material on January 1,2021(Q1) is 1490. Direct labor: Production of a single product requires 3 hours of time by employees. The employees are paid OMR 15.300 per hour. Requirements: 1. Prepare a production budget by quarters for 2021. 2. Prepare a direct materials budget by quarters for 2021. 3. Prepare a direct labor budget by quarters for 2021.

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter7: The Master Budget And Flexible Budgeting

Section: Chapter Questions

Problem 1E: The sales department of Macro Manufacturing Co. has forecast sales for its single product to be...

See similar textbooks

Similar questions

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.
Lily Inc. is preparing its annual budgets for the year ending December 31, 2022. Accounting assistants furnish the data shown below. Sales budget: Anticipated volume in units Unit selling price Production budget: Desired ending finished goods units Beginning finished goods units Direct materials budget: Direct materials per unit (pounds) Desired ending direct materials pounds Beginning direct materials pounds Cost per pound Direct labor budget: Direct labor time per unit Direct labor rate per hour Budgeted income statement: Total unit cost Product JB 50 336,000 $25 25,200 21,000 2 25,200 33,600 $3 0.4 $12 $13 Product JB 60 168,000 $30 12,600 8,400 3 8,400 12,600 $4 0.6 $12 $20 An accounting assistant has prepared the detailed manufacturing overhead budget and the selling and administrative expense budget. The latter shows selling expenses of $470,400 for product JB 50 and $302,400 for product JB 60, and administrative expenses of $453,600 for product JB 50 and $285,600 for product JB…
Crane Industries has adopted the following production budget for the first 4 months of 2027. Month Units January 10,600 Month Units March 5,300 February 8,480 April 4,240 Each unit requires 2 pounds of raw materials costing $3 per pound. On December 31, 2026, the ending raw materials inventory was 4,240 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month's production requirements. Prepare a direct materials purchases budget by month for the first quarter. > > > > > CRANE INDUSTRIES Direct Materials Purchases Budget January $ February $ $
Al Hind Company is preparing its annual budgets for the year ending December 31, 2020.Accounting assistants furnish the data shown below. Detail Product A Product C Sales Budget Anticipated Volume in units Unit Selling price Production Budget: Desired ending finished goods units Beginning finished goods units 40500 55 2500 3000 20500 45 1500 1000 Required: Prepare the following budgets for the year. Show data for each product. Budget should be prepared for. Sales Production
Phoenix Company’s 2019 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. Find the breakeven point and provide the income statement at break even Provide income statement at sales volume 12,000, 14,000, 16,000, and 18,000
Sarasota Company is preparing its manufacturing overhead budget for 2022. Relevant data consist of the following. Quarterly units production: Q1-9,800, Q2-11,100, Q3-13,000, Q4-15,400. unit. Direct labor: Labor required is 1 hour per Variable overhead costs per direct labor hour: Indirect materials $0.80; indirect labor $1.10; and maintenance $0.50. Fixed overhead costs per quarter: Supervisory salaries $40,500; depreciation $16,700; and maintenance $11,000. Prepare the manufacturing overhead budget for the year, showing quarterly data. (List variable costs before fixed costs.) First Quarter SARASOTA COMPANY Manufacturing Overhead Budget Second Quarter 1 Qı
Phoenix Company’s 2019 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. f. Find the breakeven point and provide the income statement at break even g. Provide income statement at sales volume 12,000, 14,000, 16,000, and 18,000
Phoenix Company’s 2019 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. Organize a template for variable costing income statements in which the sales volume is a variable.
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 $65? 9750000 b. If the beginning finished goods inventory is an estimated 6,000 units and the desired ending inventory is 11,000 units, how many units should be produced? 155000 c. What dollar amount of materials should be purchased at $5.50 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. 2139500 How much direct labor cost should be incurred if each unit produced requires 0.5 hours at an hourly rate of $22? How much manufacturing overhead should be incurred if fixed manufacturing overhead is $45,000 and variable…
1. AL Jamat Inc. is preparing its annual budgets for the year ending December 31, 2020.Accounting assistants furnish the data shown below. Detail Product AProduct C Sales Budget Anticipated Volume in units Unit Selling price Production Budget: Desired ending finished goods units Beginning finished goods units Direct materials budget: Direct materials per unit (pounds) Desired ending direct materials pounds Beginning direct materials pounds Cost per pound Direct labor budget: Direct labor time per unit Direct labor rate per hour Budgeted income statement: Total unit cost 40500 20500 55 45 2500 1500 3000 1000 20 30 3000 1500 4000 1000 3 0.4 0.6 122 155 122 222 has prepared An accounting assistant manufacturing overhead budget and the selling and administrative expense budget. The latter shows selling expenses of $645,000 for product A and $345,000 for product C, and administrative expenses of $545,000 for product A and $345,000 for product C. Income taxes are expected to be the detailed…
Phoenix Company’s 2019 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. Identify the unit variable costs in the format of variable costing, according to your findings in part a
DeWitt Industries has adopted the following production budget for the first 4 months of 2020. Month Units Month Units January 10,430 March 5,130 February 8,210 April 4,470 Each unit requires 3 pounds of raw materials costing $3 per pound. On December 31, 2019, the ending raw materials inventory was 6,258 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month’s production requirements.Prepare a direct materials purchases budget by month for the first quarter. DEWITT INDUSTRIESDirect Materials Purchases Budgetchoose the accounting period For the Quarter Ending March 31, 2020March 31, 2020For the Month Ending March 31, 2020 January February March select an opening materials purchases budget item Beginning Direct Materials (Pounds)Cost Per PoundDesired…