Related questions
Concept explainers
I need help on this. It's lengthy and I don't know where to start.
The sales department of Donovan Manufacturing, Inc. has completed the following sales
Each unit of J requires 3 pounds of material A and 2 pounds of material B for its manufacture; K requires 2 pounds of A and 4 pounds of B. The purchase cost of A is $9 per pound and the purchase cost of B is $5 per pound. Materials A and B on hand at January 1, 20X1, were 19,000 pounds of A and 7,000 pounds of B. Desired inventories at March 31, 20X1, are 14,000 pounds of A and 8,000 pounds of B.
Each unit of J requires 0.5 hours of direct labor in the factory; each unit of K requires 1.0 hour of direct labor. The average hourly rate for direct labor is $12 per hour. Estimated manufacturing
Cash sales for the first quarter are estimated to be $300,000 per month. It is forecast that 30% of the credit sales for the quarter ended March 31, 20X1, will occur in January, 30% in February, and 40% in March. Of credit sales (December through March), 40% will be collected as cash in the month of sale and 55% will be collected in the following month. The remainder will be uncollectible. Cash collected in January 20X1 from December 20X0 sales will be $1,050,000.
The January 1, 20X1, cash balance was $70,000. The minimum acceptable cash balance at the end of each month is $60,000. Short-term borrowings (6-month term) are made in muliples of $10,000. Interest is charged at the rate of 1% per month on short-term borrowings. The first interest payment is made the month following the borrowing. Cash disbursements (excluding interest on short-term borrowings) are estimated as follows:
| January | February | March | |
| $1,500,000 | $1,300,000 | $1,400,000 | |
| Selling and admin expenses | $390,000 | $410,000 | $400,000 |
| Interest expense | $90,000 | $90,000 | $90,000 |
| Income tax payment | 0 | 0 | $210,000 |
| Capital expenditures | $124,000 | $110,000 | $50,000 |
| Cash dividends | $300,000 | 0 | 0 |
Required:
a) Prepare the sales budget for the quarter ended March 31, 20X1.
b) Prepare the production budget for the quarter ended March 31, 20X1.
c) Prepare the direct materials budget for the quarter ended March 31, 20X1.
d) Prepare the direct labor budget for the quarter ended March 31, 20X1.
e) Prepare the manufacturing overhead budget for the quarter ended March 31, 20X1.
f) Prepare the selling and adminstrative expense budget for the quarter ended March 31, 20X1.
g) Prepare a schedule of cash collected from customers for the quarter ended March 31, 20X1.
h.) Prepare the
My note: If you can only help with a few at a time, I understand. Start with a)
Trending nowThis is a popular solution!
Step by stepSolved in 5 steps with 4 images
- Offenbach & Son has just made its sales forecasts and its marketing department estimates that the company will sell 220,200 units during the coming year. In the past, management has maintained inventories of finished goods at approximately one month's sales. The inventory at the start of the budget period is 14,800 units. Sales occur evenly throughout the year. Required: Estimate the production level required for the coming year to meet these objectives. (Do not round intermediate calculations.) Required production in unitsarrow_forwardI need help on this. It's lengthy and I don't know where to start. The sales department of Donovan Manufacturing, Inc. has completed the following sales forecast for the months of January through March 20X1 for its only two products: 50,000 units of J to be sold at $90 each and 30,000 units of K to be sold at $70 each. The desired unit inventories at March 31, 20X1, are 10% of the next quarter's unit sales forecast, which are 60,000 units of J and 30,000 units of K. The January 1, 20X1, unit inventories were 5,000 units of J and 2,000 units of K. Each unit of J requires 3 pounds of material A and 2 pounds of material B for its manufacture; K requires 2 pounds of A and 4 pounds of B. The purchase cost of A is $9 per pound and the purchase cost of B is $5 per pound. Materials A and B on hand at January 1, 20X1, were 19,000 pounds of A and 7,000 pounds of B. Desired inventories at March 31, 20X1, are 14,000 pounds of A and 8,000 pounds of B. Each unit of J requires 0.5 hours of…arrow_forwardManager Chris Channing of Fabric Mills, Inc., has developed the forecast shown in the table for bolts of cloth. The figures are in hundreds of bolts. The department has a regular output capacity of 195(00) bolts per month, except for the seventh month, when capacity will be 210(00) bolts. Regular output has a cost of $9 per hundred bolts. Workers can be assigned to other jobs if production is less than regular. The beginning inventory is zero bolts. Month Forecast Period Forecast Output Regular Overtime Output-Forecast Cost 200 Regular Overtime Total 189 210- a. Develop a chase plan that matches the forecast and compute the total cost of your plan. Overtime is $19 per hundred bolts. Regular production can be less than regular capacity (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.). 194 200 2 5 212 189 195 210 4 215 194 Total 1,415 5 212 6 195 215 Total 1,415arrow_forward
- Classic Loungers is in the process of preparing a production cost budget for August. Actual costs in July for 400 chaise lounge chairs were: Materials cost $ 6,000 Labor cost 8,000 Rent 2,000 Depreciation 4,000 Other fixed costs 5,000 Total $ 25,000 Material cost and Labor cost are considered variable. Each chair was sold for $160 in July. Management estimates that sales will increase to 440 chairs during August if the company lowers the selling price to $150 per chair. What is the incremental profit (loss) associated with the price reduction? $(200) $(2,200) $2,100 $800 $600arrow_forwardRowe Tool and Die (RTD) produces metal fittings as a supplier to various manufacturing firms in the area. The following is the forecasted income statement for the next quarter, which is the typical planning horizon used at RTD. RTD expects to sell 45,000 units during the quarter. RTD carries no inventories. Amount Per Unit Sales revenue $ 1,170,000 $ 26.00 Costs of fitting produced 900,000 20.00 Gross profit $ 270,000 $ 6.00 Administrative costs 207,000 4.60 Operating profit $ 63,000 $ 1.40 Fixed costs included in this income statement are $292,500 for depreciation on plant and machinery and miscellaneous factory operations and $94,500 for administrative costs. RTD has received a request for 10,000 fittings to be produced in the next quarter from Endicott Manufacturing. Endicott has never purchased from RTD, although they have been a local company for many years. Endicott has offered to pay $20 per unit. RTD can easily produce the 10,000 units with its existing…arrow_forwardDupont Corporation is working on its direct labor budget for the next two months. Each unit of output requires 0.41 direct labor-hours. The direct labor rate is $8.10 per direct labor-hour. The production budget calls for producing 5,000 units in May and 5,400 units in June. If the direct labor work force is fully adjusted to the total direct labor-hours needed each month, what would be the total combined direct labor cost for the two months? O $16,605.00 O $17,933.40 O $17,269.20 O $34,538.40arrow_forward
- 1arrow_forwardPainter's Hardware purchased 8,200 gallons of paint in March. The store had 3,100 gallons on hand at the beginning of March, and expects to have 2,600 gallons on hand at the end of March. What is the budgeted number of gallons to be sold during March? Round your final answer to the nearest unit. Do not include $ sign or commas in your final answer.arrow_forwardrever Ready Company expects to operate at 85% of productive capacity during May. The total manufacturing costs for May for the production of 3,900 batteries are budgeted as follows: Direct materials Direct labor Variable factory overhead Fixed factory overhead Total manufacturing costs The company has an opportunity to submit a bid for 2,000 batteries to be delivered by May 31 to a government agency. If the contract is obtained, it is anticipated that the additional activity will not interfere with normal production during May or increase the selling or administrative expenses. $324,300 119,200 33,350 67,000 $543,850 What is the unit cost below which Forever Ready Company should not go in bidding on the government contract? Round your answer to two decimal places. per unitarrow_forward
- This month your vendor invoiced $31,500 in testing charges for your production run. The unit cost for testing is twice as much for each of the first 400 units per month as compared to each unit over 400. If we shipped 500 units to the vendor this month, find: (a) Average cost per unit; (b) Cost per unit below the price break point; (c) Marginal cost for the 650th unit. The Country Fields Retirement Community charges $6000/month for a single senior citizen to reside in an efficiency apartment with assisted living care. The facility has operating expenses of $600,000 per month. Staffing levels are dependent on the number of residents.arrow_forwardCarlos Cavalas, the manager of Echo Products' Brazilian Division, is trying to set the production schedule for the last quarter of the year. The Brazilian Division had planned to sell 69,850 units during the year, but by September 30 only the following activity had been reported: Inventory, January 1 Production Sales Inventory, September 30 The division can rent warehouse space to store up to 30,700 units. The minimum inventory level that the division should carry is 2,300 units. Mr. Cavalas is aware that production must be at least 5,940 units per quarter in order to retain a nucleus of key employees. Maximum production capacity is 45,700 units per quarter. Demand has been soft, and the sales forecast for the last quarter is only 20,900 units. Due to the nature of the division's operations, fixed manufacturing overhead is a major element of product cost. Required production Required: 1-a. Assume that the division is using variable costing. How many units should be scheduled for…arrow_forwardJerry Jay is the CEO of Jerry's Jackets (JJ). In June, Jerry expects to produce and sell 3100 jackets, and he expects his June utilities cost to be $8,000 plus $0.60 per jacket. After the month ended, it was reported that 2990 jackets were sold in June and $10,190 was spent on utilities. What is the activity variance for utilities in June? Round to the nearest whole number. If the variance is Favorable, enter a positive value. If unfavorable, enter a negative value.arrow_forward
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education