Explore BrainMass

Explore BrainMass

    Olympia Productions production; Kiel Center cash collections

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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
    July 160,000
    August 170,000
    September 195,000

    Calculate the cash collections that would be included in the cash budgets for August and September. (Omit the "$" sign in your response.)

    Cash collections
    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
    June 217,000
    July 314,000
    August 406,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 $ :__________

    © BrainMass Inc. brainmass.com June 4, 2020, 1:06 am ad1c9bdddf

    Solution Summary

    Your response is in Excel so you have templates to use for future problems. Formulas are in cells.