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 5EA: Sunrise Poles manufactures hiking poles and is planning on producing 4,000 units in March and 3,700...

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.
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.
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
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
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,
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
Vaughn Company’s sales budget showed expected sales of 13480 widgets. Beginning finished goods contained 1110widgets. The company determined that 14120 units should be produced. How many widgets will the company have on hand at the end of the year? 1110 1750 640 470
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.
Tillman Cycles manufactures chainless bicycles. On March 31, Tillman Cycles had 210 bikes in inventory. The company has a policy that the ending inventory in any month must be 20% of the following month's expected sales. Tillman Cycles expects to sell the following number of bikes in each of next four months: E (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. ..... Tillman Cycles Production Budget For the Months of April through June Data Table April May June Quarter Unit sales 1050 1150 1390 3590 Plus: Desired ending inventory April. 1,050 bikes Total needed May 1,150 bikes Less: Beginning inventory June. 1,390 bikes Units to produce July . 1,200 bikes Print Done