After completing their sales forecast, Fido Treats LLC has decided that it would like to create a production budget. The company's goal is to ensure that it will be able to produce enough dog treats to cover the sales that have been projected for the entire 1st quarter. Fido has projected the following sales: January 1,109 units, February 1242 units, March 1391 units, April 1405 units. The company has a policy of keeping 15% of the next month's projected sales on hand in their Finished Goods (FG) Inventory. Calculate the number of budgeted units that need to be produced for each and for the entire quarter.

After completing their sales forecast, Fido Treats LLC has decided that it would like to create a production budget. The company's goal is to ensure that it will be able to produce enough dog treats to cover the sales that have been projected for the entire 1st quarter. Fido has projected the following sales: January 1,109 units, February 1242 units, March 1391 units, April 1405 units. The company has a policy of keeping 15% of the next month's projected sales on hand in their Finished Goods (FG) Inventory. Calculate the number of budgeted units that need to be produced for each and for the entire quarter.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 5EB: Cloud Shoes manufactures recovery sandals and is planning on producing 12.000 units in March and...

See similar textbooks

Similar questions

If the sales forecast estimates that 50,000 units of product will be sold during the following year, should the factory plan on manufacturing 50,000 units in the coming year? Explain.
One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit. Prepare a sales budget. Thunder Creek wants to finish each month with 20% of next month's sales in units. Prepare a production budget. (When entering answers in the production budget, use the sales budget for your cell references. Enter all values as positive--without a minus sign--in row 18.) Hint: Beginning inventory for the period is equal to the ending inventory of the previous period.
Suncat has asked you to prepare a sales budget and production budget for the first quarter of the year using the following information: Selling price of custom wedding cake: $800 Expecting to sell 200 wedding cakes in January and a 10% increase in each month for the next 6 months The required ending inventory is 20% of next month’s sales. Suncat Cake Shop Sales Budget For the Quarter Ended March 31, 2021 January February March Total Expected Sales (Units) Selling Price per Wedding Cake Total Sales Revenue Suncat Cake Shop Production Budget For the Quarter Ended March 31, 2021 January February March Expected Sales (Units) Desired Ending Inventory (Units) Total Required Units Less: Beginning Inventory Required Production
Tiger Stripes, Inc. manufactures plush animals in the shape of Tigers. They expect to have the following Sales in the first half of 2018 – January 100000 units, February, 150000 units, March 200000 units, April 250000 units, May 300000 units and June 350000 units. Management would like you to prepare two (2) Sales Budgets – one at the current price of $12 per unit and one by increasing the price by 10% per month. -Sales Budget #1 - $12 per unit -Sales Budget #2 – 10% increase budget.
Coronado Company estimates that unit sales will be 11,800 in quarter 1, 16,520 in quarter 2, 17,700 in quarter 3, and 21,240 in quarter 4. The unit selling price is $70. Management desires to have an ending finished goods inventory equal to 25% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first 6 months of 2025,
Trapper Cycles manufactures chainless bicycles. On March 31, Trapper Cycles had 309 bikes in inventory. The company has a policy that the ending inventory in any month must be 30% of the following month's expected sales. Trapper Cycles expects to sell the following number of bikes in each of next four months: (Click the icon to view the data) Prepare a production budget for the second quarter, with a column for each month and for the quarter. Trapper Cycles Production Budget For the Months of April through June April May Unit sales Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce 1030 Data table April May June July 1160 June 1340 Quarter 1,030 bikes 1,160 bikes. 1,320 bikes. 1,250 bikes 3530 - X
Hansell Company's management wants to prepare budgets for one of its products, Duraflex, for July 2019. The firm sells the product for $97 per unit and has the following expected sales (in units) for these months in 2019: July April August September 9,400 May 7,100 June 7,200 3, зее 9,400 4,600 The production process requires 4 pounds of Dura-1000 and 2 pounds of Flexplas. The firm's policy is to maintain an ending inventory each month equal to 10% of the following month's budgeted sales, but in no case less than 500 units. All materials inventories are to be maintained at 5% of the production needs for the next month, but not to exceed 1,000 pounds. The firm expects all inventories at the end of June to be within the guidelines. The purchases department expects the materials to cost $1.25 per pound and $5.00 per pound for Dura-1000 and Flexplas, respectively. The production process requires direct labor at two skill levels. The rate for labor at the K102 level is $50 per hour and $20…
Hamlett Company has prepared its sales budget for the first two quarters of 2024. Expected sales in units are 600,000 in the first quarter and 800,000 in the second quarter Hamlett Company likes to maintain an inventory at the end of each quarter equal to one -fourth of the next quarter's expected sales . The company had 150,000 units in inventory at the beginning of the first quarter (January 1 , 2024 ). How many units will Hamlett Company need to produce during the first quarter of 2024 ? 800,000 units 600,000 units None of the listed choices are correct 650,000 units 950,000 units
Angelo Limited is preparing its budget for the next year. It produces and sells a single product. The expected sales for the first 4 months of next year are: Month January February March April Production units 10,500 12,700 14,200 16,100 The product requires 2.5 kg of Material A1 per unit. It is the company’s policy to hold in inventory at the end of a month 20% of the material requirement for the following month. Calculate the material purchases for the month of February based on the information provided. Production cost is: The total overhead cost incurred in producing products. The total of the direct costs and the production overhead cost incurred. The total of the direct costs incurred in production. The cost of direct material, direct labour and indirect labour incurred in production.
Hansell Company’s management wants to prepare budgets for one of its products, Duraflex, for July 2019. The firm sells the product for $85 per unit and has the following expected sales (in units) for these months in 2019: April May June July August September 4,500 5,900 6,000 7,000 8,000 7,000 The production process requires 4 pounds of Dura-1000 and 2 pounds of Flexplas. The firm’s policy is to maintain an ending inventory each month equal to 10% of the following month’s budgeted sales, but in no case less than 500 units. All materials inventories are to be maintained at 5% of the production needs for the next month, but not to exceed 1,000 pounds. The firm expects all inventories at the end of June to be within the guidelines. The purchases department expects the materials to cost $1.25 per pound and $5.00 per pound for Dura-1000 and Flexplas, respectively. The production process requires direct labor at two skill levels. The rate for labor at the K102 level is $50…