Explore BrainMass
Share

Explore BrainMass

    7-28 7-37 7-39 Products Budgets COGS production cost cuts

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

    7-28
    Ronoco Products, a wholesaler of fishing equipment, budgeted the following sales for the indicated months:

    June 20X8 July 20X8 August 20X8
    Sales on account $1,820,000 $1,960,000 $2,100,000
    Cash sales 280,000 240,000 260,000
    Total sales $2,100,000 $2,200,000 $2,360,000

    All merchandise is marked up to sell at its invoice cost plus 25%. Target merchandise inventories at the beginning of each month are 30% of that month's projected cost of goods sold.
    1. Compute the budgeted cost of goods sold for the month of June 20X8
    2. Compute the budgeted merchandise purchases for July 20X8.

    7-37
    Prepare a statement of estimated cash receipts and disbursements for October 20X7 for the Botanica Company, which sells one product, herbal soap, by the case. On October 1, 20X7, part of the trial balance showed the following:
    DR CR
    Cash $4,800
    Accounts receivable 15,600
    Allowance for bad debts $1,900
    Merchandise inventory 9,000
    Accounts payable, merchandise 6,600

    The company pays for its purchases within 10 days of purchase so assume that one-third of the purchases of any month are due and paid for in the following month. The cost of the merchandise purchased is $12 per case. At the end of each month, it is desired to have an inventory equal in units to 50% of the following month's sales in units. Sales terms include a 1% discount if payment is made by the end of the calendar month. Past experience indicates that 60% of sales will be collected during the month of the sale, 30% in the following calendar month, 6% in the next following calendar month, and the remaining 4% will be uncollectible. The company's fiscal year begins August 1.
    Unit selling price $20
    August actual sales $12,000
    September actual sales 36,000
    October estimated sales 30,000
    November estimated sales 22,000
    Total sales expected in the fiscal year $360,000
    Exclusive of bad debts, total budgeted selling and general administrative expenses for the fiscal year are estimated at $61,500, of which $24,000 is fixed expense (which includes a $13,200 annual depreciation charge). The Botanica Company incurs these fixed expenses uniformly throughout the year. The balance of the selling and general administrative expenses varies with sales. Expenses are paid as incurred.

    7-39
    A recent directive from Sandy Jensen, CEO of Duluth Manufacturing, had instructed each department to cut its costs by 10%. The traditional functional budget for the shipping and receiving department was as follows:
    Salaries, four employees at $42,000 $168,000
    Benefits at 20% 33,600
    Depreciation, straight-line basis 76,000
    Supplies 43,400
    Overhead at 35% of direct costs 112,350
    Total $433,350
    Therefore, the shipping and receiving department needed to find $43,335 to cut. June Steele, a recent MBA graduate, was asked to pare $43,335 from the shipping and receiving department's budget. As a first step, she recast the traditional budget into an activity-based budget.
    Receiving 620,000 pounds $93,000
    Shipping, 404,000 boxes 202,000
    Handling, 11,200 moves 112,000
    Record keeping, 65,000 transactions 26,350
    Total $433,350

    1. What actions might Steele suggest to attain a $43,335 budget cut? Why would these be the best actions to pursue?
    2. Which budget helped you most in answering number 1? Explain.

    © BrainMass Inc. brainmass.com October 10, 2019, 6:25 am ad1c9bdddf
    https://brainmass.com/business/purchases-inventory-and-cogs/7-28-7-37-7-39-products-budgets-cogs-production-cost-cuts-543417

    Solution Preview

    Problem posted:

    7-28
    Ronoco Products, a wholesaler of fishing equipment, budgeted the following sales for the indicated months:

    June 20X8 July 20X8 August 20X8
    Sales on account $1,820,000 $1,960,000 $2,100,000
    Cash sales 280,000 240,000 260,000
    Total sales $2,100,000 $2,200,000 $2,360,000

    All merchandise is marked up to sell at its invoice cost plus 25%. Target merchandise inventories at the beginning of each month are 30% of that month's projected cost of goods sold.
    1. Compute the budgeted cost of goods sold for the month of June 20X8
    2. Compute the budgeted merchandise purchases for July 20X8.

    7-37
    Prepare a statement of estimated cash receipts and disbursements for October 20X7 for the Botanica Company, which sells one product, herbal soap, by the case. On October 1, 20X7, part of the trial balance showed the following:
    DR CR
    Cash $4,800
    Accounts receivable 15,600
    Allowance for bad debts $1,900
    Merchandise inventory 9,000
    Accounts payable, merchandise 6,600

    The company pays for its purchases within 10 days of purchase so assume that one-third of the purchases of any month are due and paid for in the following month. The cost of the merchandise purchased is $12 ...

    Solution Summary

    Your tutorial in excel is attached and indicates the process and the structure to approach this problem. Your tutorials are templates useful in future problems.

    $2.19