
Concept explainers
This problem has several components…
Last year sales = 500,000 units. The organization is planning a 10 percent increase in sales for the year 2012. The company is a retail organization that sees higher sales due to the holidays in the 4th quarter. 40 percent of the sales occur in the 4th quarter and the remaining units are sold equally over the other three quarters.
The beginning inventory for the year amounts to 20,000 units. The estimated sales for the first quarter of 2022 amount to 115,000 units. The company requires an ending inventory of 20 percent of the next quarters' sales.
The projected sales price is $50 per unit.
Materials: Each unit requires 1 yard of fabric and 1/2 pound of fiberfill stuffing. Fabric can be purchased at $9.00 per yard and fiberfill sells for $4.00 per pound. Desired ending inventories of materials are
listed as follows: |
|
|
|
|
|
Qtr1 |
Qtr2 |
Qtr3 |
Qtr4 |
Fabric/yds |
17,000 |
20,000 |
18,000 |
19,000 |
Fiberfill/lbs |
5,000 |
6,700 |
8,000 |
8,500 |
Beginning inventory of fabric is 16,000 yards and 6,000 lbs. of fiberfill. It takes an estimated time of .25 hours to produce one unit of output. The labor cost per hour is $25 per hour and the taxes and benefit load is 25 percent.
Required:
- Prepare a quarterly sales budget in units and dollars.
- Prepare a quarterly production budget in units.
- Prepare a quarterly purchase budget for fabric and fiberfill.
- Prepare a quarterly labor budget.

Trending nowThis is a popular solution!
Step by stepSolved in 5 steps

- Philip Inc. expects their sales to increase by $900,000 next month. If their CMR is calculated as 48%, operating income of the next month would be expected to: Group of answer choices Increase by $432,000 Decrease by $468,000 Decrease by $432,000 Increase by $468,000arrow_forwardHello, I could really use some help with this. I am struggling. Thank youarrow_forwardWildcat, Incorporated, has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $170 $185 $200 $225 Sales for the first quarter of the year after this one are projected at $180 million. Accounts receivable at the beginning of the year were $71 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 45 percent of the next quarter's forecast sales, and suppliers are normally paid in 36 days. Wages, taxes, and other expenses run about 25 percent of sales. Interest and dividends are $14 million per quarter. Wildcat plans a major capital outlay in the second quarter of $85 million. Finally, the company started the year with a $54 million cash balance and wishes to maintain a $30 million minimum balance. Assume that Wildcat can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter and can Invest any excess funds in short-term marketable securities at a rate of 2 percent per…arrow_forward
- Fairchild Garden Supply expects $580 million of sales this year, and it forecasts a 15% increase for next year. The CFO uses this equation to forecast inventory requirements at different levels of sales: Inventories = $30.2 + 0.25(Sales). All dollars are in millions. The firm's cost of goods sold is expected to be 70% of sales. What is the projected inventory turnover ratio for the coming year? Please explain process and show calculations.arrow_forwardA8 please help....arrow_forwardViolet Sales Corp, reports the year-end information from 2023 as follows: Sales (35,500 units) $284,000 Cost of goods sold 105,000 Gross margin 179,000 Operating expenses 152,000 Operating income $27,000 Violet is developing the 2024 budget. In 2024 the company would like to increase selling prices by 3.5%, and as a result expects a decrease in sales volume of 14%. All other operating expenses are expected to remain constant. Assume that cost of goods sold is a variable cost and that operating expenses are a fixed cost. What is budgeted sales for 2024?arrow_forward
- Sunland Company estimates its sales at 180000 units in the first quarter and that sales will increase by 17000 units each quarter over the year. They have, and desire, a 25% ending inventory of finished goods. Each unit sells for $25. 40% of the sales are for cash. 70% of the credit customers pay within the quarter. The remainder is received in the quarter following sale. Cash collections for the third quarter are budgeted at O $5273500. O $3026500. O $4387000. O $6057389.arrow_forwardBuffalo Company’s budgeted sales and budgeted cost of goods sold for the coming year are $149,520,000 and $103,320,000, respectively. Short-term interest rates are expected to average 10%. If Buffalo can increase inventory turnover from its present level of 9 times a year to a level of 12 times per year.Compute its expected cost savings for the coming year.arrow_forwardA8arrow_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:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education





