Calculate cost of goods manufactured

Assignment Help Cost Accounting
Reference no: EM13327504

Betty s Beautiful Baskets, a manufacturing business that sells baskets, wants a master budget prepared for the first three months of this year (January, February and March).

The managers of the different departments have provided the following information:

The Sales Manager has projected the following sales:

o January 5,000 units

o February 4,000 units

o March 6,000 units

o April 5,000 units

o May 11,250 units

o Projected selling price is $35.00/unit

Your Production Manager gave the following information:

o Ending Inventory is to be 20% of next month s production needs

o April s Projected Sales 5,000 units

o December 20X5 Ending Inventory was 1,000 units and December unit cost was $23.50.

The Manufacturing Manager has estimated the following:

o Each unit will require 4 grams of material

o Material in Ending Inventory is 20% of next month s needs

o December s Ending Material Inventory was 4,800 g

o Projected cost of material: $2.50/gram

The Personnel Manager has estimated that Direct Labor will be projected at:

o 0.75 hours of Direct Labor per unit

o Direct Labor Cost: $8.50/hour

The Facilities Manager has estimated that the Manufacturing Overhead will be projected at:

o Variable Overhead Rate to be $8 per Direct Labor hours

o Fixed Overhead Rate to be $3,000 per month

The Accounting Department Manager has provided the following information:

Selling and Administrative Expenses are projected to be a monthly cost of:

o Salaries $6,000

o Rent $1,500

o Advertising $1,100

o Telephone $300

o Other $500

Betty s Beautiful Baskets Page 2

Cash Receivable:

o December s Sales were $150,000

o 80% of sales is collected in the month in which they were made

o 20% of sales collected in the following month in which they were made

o Bad Debts is negligible

Accounts Payable:

o 80% of Payables is paid for in the current month

o 20% of Payables is paid for in the following month

o December s purchases were $50,000

Federal Income Tax is estimated at 22% average.

Betty s Beautiful Baskets

o has a $20,000 cash balance for the beginning of January

o pays Dividends of $8,000 to be paid in March

o pays projected Federal Income tax in March

o depreciation on the building is $150 per month

o does not carry any WIP inventory

o uses FIFO inventory costing

From the beginning Balance Sheet:

o Land = $150,000

o Building = $45,000

o Depreciation (Building) = $11,250

o Retained Earnings = $58,780

o Capital Stock = $200,470

For the Master Budget, you are expected to prepare the following:

Sales budget plus schedule of accounts receivable collections

Production budget

Direct materials budget and schedule of cash payments for purchases

Direct labor budget

Manufacturing overhead budget

Cost of Goods Sold Budget

Selling & Administrative Expenses Budget

Budgeted income statements

Cash budget

Budgeted balance sheet for each month plus a beginning balance sheet

When you prepare the cost of goods sold budget, you must calculate a unit cost for each month. You must also calculate cost of goods manufactured. Remember, there is no Work in Process inventory but you must calculate direct materials used.

Reference no: EM13327504

Questions Cloud

Increase output but by a factor of what : Due to the presence of dimishing returns to capital, doubling the amount of physical capital available for one worker to use will:
How does the maximum height change : If the initial speed of the ball is doubled, how does the maximum height change
How long is the cord : A cord with a mass of 500g is tied between two supports. The tension in the cord is 35N and it takes a wave 0.55s to travel from one end to the other. How long is the cord
At what point will a firm shut-down support your answer : At what point will a firm shut-down? Support your answer with a graph. Explain, why will the firm continue to operate even when its profits are negative?
Calculate cost of goods manufactured : Calculate a unit cost for each month. You must also calculate cost of goods manufactured. Remember, there is no Work in Process inventory but you must calculate direct materials used.
What is the value of your retirement plan after the 40 years : Assume that you contribute $240 per month to a retirement plan for 15 years. Then you are able to increase the contribution to $480 per month for another 25 years.
In benchmarking sales representatives against one another : In benchmarking sales representatives against one another, what problems arise from continuing to reassign the above-average trade representatives to previously unproductive sales territories?
How many km can it travel on one tank : A tank of a car holds 16 gallons , a liter is .264 gallons, 1 inch equal 2.54 cm, and 1mile equal 1609 m, how many km can it travel on one tank if it gets 25mpg
Find ebit indifference level associated with financing plans : To finance the new venture two plans have been proposed. Plan A is an all common equity structure in which $2.3 million dollars would be raised by selling 86,000 shares of common stock.

Reviews

Write a Review

 

Cost Accounting Questions & Answers

  Evaluate what is emma''s basis in her partnership interest

Evaluate what is Emma's basis in her partnership interest and find what is Laine's basis in her partnership interest what basis does the partnership take in property transferred by Laine

  Create a pie chart for total assets

Create the Balance Sheet,Income Statement and Statement of Retained Earnings for the following company in an Excelworkbook, employing three sheets.

  Purpose an unadjusted trial balance

Purpose an unadjusted trial balance as of April 30, 2007. Set up suitable T-accounts. All accounts begin with zero balances.

  Calculate the present values of the cash flows

For each of the itineraries, calculate the present values of the cash flows using required rates of return of both 10% and 15% Assume a 15 -year time horizon. Should the company purchase the ship with either or both required rates of return..

  Create subsequent journal entry to show spending of funds

Create the journal entry or entries to show the proper recording of revenue and create the subsequent journal entry to show spending of the funds.

  Watts and zimmerman''s

Watts and Zimmerman's 'The Demand and Supply of Accounting Theories: The Market for Excuses' suggested the 'normative' project of accounting academics and other social critics of corporate accounting practice to be invalid

  Find how much clay should be purchased in september

The company needs to maintain monthly ending inventories of clay equal to 20% of the subsequent month's production required. On August 31, 18,000 pounds of clay were on hand.

  Costing systems and traditional overhead allocation systems

Show the main differences between ABC costing systems and traditional overhead allocation systems. Based on your knowledge and experience, which technique you prefer and why?

  Problem on traditional costing procedures

Overhead cost allocated to Beta by using traditional costing procedures would be and overhead cost allocated to Beta by using activity-based costing procedures

  Find return-on-assets ratio and net-profit-margin ratio

LONE PINE COMPANY Statement of Income and Retained Earnings For the Year Ending December 31,20X2 ($000 Omitted) Net Sales* $36,000 Less: Cost of Goods Sold $20,000 Selling Expense 6,000 Administrative Expense 4,000 Interest Expense 400

  How to allocate total cost among the three purchased assets

Liltua Company pays $375,280 for real estate plus $20,100 in closing costs. The real estate consists of land appraised at $157,040; land improvement appraised at $58,890; and a building appraised at $176,670. Allocate the total cost among the thre..

  Prepare journal entries for mcdaniel

Prepare journal entries on 1/1/2015 for McDaniel Prepare journal entries on 12/31/2015 for McDaniel

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd