1. Olympia Productions, Inc., makes award medallions that are attached to ribbons. Each medallion requires 18 inches of ribbon. The sales forecast for February is 8,000 medallions. Estimated beginning inventories and desired ending inventories for February are:
Beginning Inventory Desired Ending Inventory
Medallions 4,000 3,200
Ribbon (yards) 200 80
(a) Calculate the number of medallions to be produced in February.
(b) Calculate the number of yards of ribbon to be purchased in February.
2. Kiel Center's sales are all made on account. The firm's collection experience has been that 35% of a month's sales are collected in the month the the sale is made, 55% are collected in the month following the sale, and 8% are collected in the second month following the sale. The sales forecast for the months of June through September is:
June $ 140,000
August $: __________
September $: __________
3. Brooklyn Furniture, a retail store, has an average gross profit ratio of 48%. The sales forecast for the next four months follows:
May $ 251,000
Management's inventory policy is to have ending inventory equal to 340% of the cost of sales for the subsequent month, although it is estimated that the cost of inventory at April 30 will be $419,000.
Calculate the purchases budget, in dollars, for the months of May and June.
May $: __________
June $ :__________
Your response is in Excel so you have templates to use for future problems. Formulas are in cells.