Concept explainers
Morganton Company makes one product and it provided the following information to help prepare the
- The budgeted selling price per unit is S70. Budgeted unit sales for June; July; August and September are 8,400, 10,000, 12,000, and 13,000 units, respectively. All sales are on credit.
- Forty percent of credit sales are collected in the month of the sale and 60% in the following month.
- The ending finished goods inventory equals 20% of the following month’s unit sales.
- The ending raw materials inventory equals 10% of the following month’s raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. The raw materials cost $2.00 per pound.
- Thirty percent of raw materials purchases are paid for in the month of purchase and 70% in the following month.
- The direct labor wage rate is $15 per hour. Each unit of finished goods requires two direct labor-hours.
- The variable selling and administrative expense per unit sold is $1.80. The fixed selling and administrative expense per month is $60,000.
Required:
6. What is the estimated cost of raw materials purchases for July?
Concept Introduction:
Budgets:
Budgets are prepared to estimate the revenue, costs, receipts and payments for the business. There are several types of budgets prepared for a manufacturing concern. Few major types of budgets prepared by each manufacturing concert are as follows:
- Sales budget
- Cash Collection budget
- Production budget
- Raw material purchase budget
- Cash disbursement budget
Production Budget:
The Production budget is prepared after preparing the sales budget to estimate the number of units of finished goods to be produced. The formula for calculation for production units is as follows:
Raw Material Purchase Budget:
The Raw Material Purchase Budget is prepared after preparing the production budget to estimate the amount of Raw materials to be purchased. The formula for calculation for Raw material purchase is as follows:
The Cost of Raw Material Purchases for July
Explanation of Solution
The Cost of Raw Material Purchases for July is $105,800
The calculation of Cost of Raw Material Purchased for July is as follows:
Production Budget | ||||
June | July | August | September | |
Budgeted Unit Sales (A) | 8,400 | 10,000 | 12,000 | 13,000 |
Add: Desired Ending Finished Goods Inventory (20% of next month's sales) | 2000 | 2400 | 2600 | |
Less: Beginning Finished Goods Inventory | -2000 | -2400 | ||
Production Units | 10,400 | 12,200 |
Working notes:
1. The Desired Ending Finished Goods Inventory (20% of next month's sales) are calculated as follows:
June: 20% of July Sales = 20% of 10,000 units = 2,000 units
July: 20% of August Sales = 20% of 12,000 units = 2,400 units
August: 20% of September Sales = 20% of 13,000 units = 2,600 units
2. Beginning Finished Goods Inventory fir each month shall be equal to the previous month’s Ending Finished Goods Inventory.
Raw Material Purchase Budget | |||
June | July | August | |
Production units (A) | 10,400 | 12,200 | |
Pound of Raw Material required for each unit of finished goods (B) | 5 | 5 | |
Total Raw material production need (Pounds) (C) = A*B = | 52,000 | 61,000 | |
Add: Desired Ending Raw material Inventory (10% of next raw material production need) | 5200 | 6100 | |
Less: Beginning Raw materials Inventory | -5200 | ||
Raw Material Purchase (Pounds) | 52,900 |
Working notes:
1. The Desired Ending Raw material Inventory (10% of next raw material production need) is calculated as follows:
June: 10% of July raw material production need = 10% of 42,000 pounds = 5,200 units
July: 10% of August raw material production need = 10% of 61,000 pounds = 6,100 units
2. Beginning Raw materials Inventory for each month shall be equal to the previous month’s Ending Raw materials Inventory.
Hence, the Raw material purchase for July is 52,900 Pounds. The raw material cost per pound is given $2.
Hence,
Want to see more full solutions like this?
Chapter 8 Solutions
MANGERIAL ACC.(LOOSE)W/CONNECT CUST.>IC
- 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.arrow_forwardPalmgren Company produces consumer products. The sales budget for four months of the year is presented below. Company policy requires that ending inventories for each month be 25 percent of next months sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.arrow_forwardDigital Solutions Inc. uses flexible budgets that are based on the following data: Prepare a flexible selling and administrative expenses budget for October for sales volumes of 500,000, 750,000, and 1,000,000.arrow_forward
- 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?arrow_forwardLens 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.arrow_forwardPilsner 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?arrow_forward
- Using the provided budgeted information for production of 10,000 and 15,000 units, prepare a flexible budget for 17,000 units.arrow_forwardBefore the year began, the following static budget was developed for the estimated sales of 50,000. Sales are higher than expected and management needs to revise its budget. Prepare a flexible budget for 100,000 and 110,000 units of sales.arrow_forwardTIB 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.arrow_forward
- A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000arrow_forwardBudgeted income statement and supporting budgets for three months Bellaire Inc. gathered the following data for use in developing the budgets for the first quarter (January, February, March) of its fiscal year: Estimated sales at 125 per unit: Estimated finished goods inventories: Work in process inventories are estimated to be insignificant (zero). Estimated direct materials inventories: Manufacturing costs: Selling expenses: Instructions Prepare the following budgets using one column for each month and a total column for the first quarter, as shown for the sales budget: Prepare a sales budget for March. Prepare a production budget for March. Prepare a direct materials purchases budget for March. Prepare a direct labor cost budget for March. Prepare a factory overhead cost budget for March. Prepare a cost of goods sold budget for March. Prepare a selling and administrative expenses budget for March. Prepare a budgeted income statement with budgeted operating income for March.arrow_forwardUsing the following budgeted information for production of 5,000 and 12,000 units, prepare a flexible budget for 9,000 units.arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning