Draw up a material purchase budget from the following information: Use the given format. Estimated sales of a product is 50,000 units. Two kinds of raw materials A and B are required for manufacturing the product. Each unit of the product requires 3 units of A and 4 units of B. The estimated opening balance in the beginning of the next year: finished goods 10,000 units; A, 15,000 units; B, 20,000 units. The desirable closing balance at the end of the next year: finished product, 8,000 units; A, 10,000 units; B 12,000 units. Material Purchase Budget for the Year Material A Units Particulars Material B Units Material Required to meet Production Target Material A-33,000 x 3 Material B- 33,000 x 4 Add : Desired closing stock at the end of next year Totals Less : Expected stock at the commencement of next year (opening balance) Quantity of Materials to be purchased

Draw up a material purchase budget from the following information: Use the given format. Estimated sales of a product is 50,000 units. Two kinds of raw materials A and B are required for manufacturing the product. Each unit of the product requires 3 units of A and 4 units of B. The estimated opening balance in the beginning of the next year: finished goods 10,000 units; A, 15,000 units; B, 20,000 units. The desirable closing balance at the end of the next year: finished product, 8,000 units; A, 10,000 units; B 12,000 units. Material Purchase Budget for the Year Material A Units Particulars Material B Units Material Required to meet Production Target Material A-33,000 x 3 Material B- 33,000 x 4 Add : Desired closing stock at the end of next year Totals Less : Expected stock at the commencement of next year (opening balance) Quantity of Materials to be purchased

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 18M

See similar textbooks

Similar questions

Each unit requires direct labor of 4.1 hours. The labor rate is $13.75 per hour and next years production is estimated at 75,000 units. What is the amount to be included in next years direct labor budget?
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?
Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Speedy Petes on the previous page. Coefficients shown by a regression program for Speedy Petes data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of deliveries and the variable rate per delivery. 2. Construct the cost formula for total delivery cost. 3. Calculate the budgeted cost for next month, assuming that 3,000 deliveries are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-26 through 3-29: Speedy Petes is a small start-up company that delivers high-end coffee drinks to large metropolitan office buildings via a cutting-edge motorized coffee cart to compete with other premium coffee shops. Data for the past 8 months were collected as follows:
Cloud Shoes manufactures recovery sandals and is planning on producing 12.000 units in March and 11,500 in April. Each sandal requires 1.2 yards if material, which costs $3.00 per yard. The companys policy is to have enough material on hand to equal 15% of next months production needs and to maintain a finished goods inventory equal to 20% of the next months production needs. What is the budgeted cost of purchases for March?
Use the information below for Mandy Corporation to answer the question that follow. Mandy Corporation sells a single product. Budgeted sales for the year are anticipated to be 696,000 units, estimated beginning inventory is 106,000 units, and desired ending inventory is 89,000 units. The quantities of direct materials expected to be used for each unit of finished product are given below.Material A: 0.50 lb. per unit @ $0.71 per poundMaterial B: 1.00 lb. per unit @ $1.89 per poundMaterial C: 1.20 lb. per unit @ $0.84 per poundThe dollar amount of Material B used in production during the year is
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.
Compute the dollar amount of Direct Material "A" to be used in production during the year, given the following info: Budgeted Sales for the year = 640,000 units Estimated Beg. Inventory = 108,000 units Desired End. Inventory = 90,000 units The Quantities of Direct Materials expected to be used for each Unit of finished product are as follows: Material A = 0.5 lb. per unit @ $0.60 per lb. Material B 1.0 lb. per unit @ $1.70 per lb. Material C= 1.2 lb. per unit @ $1.00 per lb. O $186,600.00 $210,600.00 O$181,200.00 $240,000.00
produces two products, A and Z. In the year ending 30 April 2020, it produced 6,000 A and 12,500 Z and incurred costs of $1,850,000 The costs incurred are such that 30% are variable. 60% of these variable costs vary with the number of Z produced, with the remainder varying with the output of A. The budget for the three months to 31 October 2020 is being prepared using an incremental approach based on the following: All costs will be 6% higher than the average paid in the year ended 30 April 2020. • Efficiency levels will be unchanged. • Expected output: A 1,350 units 6,890 units Instructions: What is the budgeted cost for the output of A (to the nearest $100) for the 3 months ending 31 October 2020?
Taylor corpration is analyzing the cost behavior of three cost items, A, B, and C, to budget for the upcomng year. Past trends have indicated the following dollars were spent at three different levels of outpuut. Unit Levels 10,000 12,000 15,000 A costs 25,000 29,000 35,000 B costs 10,000 15000 15000 C costs 15,000 18,000 22500 In establishing a budget for 14,000 units, Taylor should treat A, B, and C costs as: a. semivariable, fixed and variable respectively. b. variable, fixed, and variable, respectively. c. semivariable, semivariable, and semivariable, respectively. d. variable, semivariable, and semivariable, respectively.
The production department of Headstrong Company has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 8,100 9,100 7,100 6,100 In addition, the beginning raw materials inventory for the first quarter is budgeted to be 1,950 kilograms and the beginning accounts payable for the first quarter are budgeted to be $3,490. Each unit requires 3.1 kg of raw material that costs $2.50 per kilogram. Management desires to end each quarter with an inventory of raw materials equal to 10% of the following quarter’s production needs. The desired ending inventory for the fourth quarter is 2,325 kilograms. Management plans to pay for 80% of raw material purchases in the quarter acquired and 20% in the following quarter. Each unit requires 0.6 direct labour-hours, and direct labour-hour workers are paid $19.5 per hour. Required: 1-a. Prepare the company's direct…
Apparelle Co. developed the following equation to predict certain components of its budget for the coming period: Costs = $50,000 + ($5 x direct labor hours) The $5 would approximate:a. total costb. direct labor rate per hourc. fixed cost per direct labor hourd. variable costs per direct labor hour
The production department of Headstrong Company has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th G Quarter Units to be produced 7,000 8,000 6,000 5.000 In addition, the beginning raw materials inventory for the first quarter is budgeted to be 1,400 kilograms and the beginning accounts payable for the first quarter are budgeted to be $2,940. Each unit requires two kilograms of raw material that costs $1.40 per kilogram. Management desires to end each quarter with an inventory of raw materials equal to 10% of the following quarter's production needs. The desired ending inventory for the fourth quarter is 1, 500 kilograms. Management plans to pay for 80% of raw material purchases in the quarter acquired and 20% in the following quarter. Each unit requires 0.60 direct labour - hours, and direct labour - hour workers are paid $14 per hour. Required: 1. Prepare the company's direct materials budget…