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.

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.