Question

Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells...

Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells a single product for $20 a unit.  Sales are 25% cash and 75% credit.  The credit sales are collected 30% in the month of the sale and the remaining 70% is collected in the next month.  No credit sales occurred in December 2008. The December 31 inventory of finished goods is 15,000 units and projected sales are 20,000, 55000, 65,000, 75,000, and 85,000 units for the first  months of the year.  The desired ending inventory for each month is 35% of the next month's sales. The inventory of Finished Goods expected to be on hand on April 30 is 10,500 units.  Each Finished Unit requires 2 kilograms of materials at a cost of $1.00 per kilo and it takes 15 minutes to complete one unit.  Evergreen anticipates having 20,000 kilos of materials on hand at December 31, 2008.  The company requires 15% of the next month production materials needs to be available before the start of the month.  Labour is paid at the rate of $9.00 per hour and is paid when incurred.  Production overhead is incurred based on units of production and costs $1.50 per unit. Sixty percent of the purchases are paid in the month of purchase and 40% are paid in the following month.  Purchases in December 2008 were $232,500.

Operating expenses are paid in the month incurred and consist of sales commissions (8% of sales), shipping cost (4% of sales), office salaries of $15,000 a month, advertising of $2,800 per month,  and amortization of $3,200 per month, and other miscellaneous expenses of $4,500 per month.  The cash balance must not be negative. The beginning cash balance is $48,000.  Loans are obtained at the end of the month in which a cash shortage occurs and are made in even multiples of $1,000.  Interest is 1% per month based on the beginning-of-month loan balance and must be paid at the end of each month when the loan is repaid.   Evergreen paid $4,000 in cash dividends in January and purchased land for $150,000 in March paying cash.

Direct Labour Budget
January February March TOTAL
Production Units
Labour hours / unit
Labour Hours Required
Hourly Rate
Direct Labour Cost

Homework Answers

Answer #1

Calculate direct labor budget

January February March Total
Production units 24250 58000 68500 151250
Labour hours / unit 15/60 = 0.25 0.25 0.25 0.25
Labour Hours Required 6062.50 14500 17125 37687.50
Hourly Rate 9 9 9 9
Direct Labour Cost 54562.50 130500 154125 339187.5

Production budget

January February March Total April
Sales 20000 55000 65000 140000 75000
Add: Desired end. Inventory 19250 22750 26250 26250 29750
Total Needs 39250 77750 91250 166250 104750
Less Beg. Inventory -15000 -19250 -22750 -15000 -26250
Units to be produced 24250 58500 68500 151250 78500
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalton ​Manufacturing's operations: Current Assets as of December 31 (prior year): Cash. . . . . . . . . . . . . . . . . . . . . . . . . . .$4,460 Accounts receivable, net. . . . . . . . . . . $48,000 Inventory. . . . . . . ....
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Hamby Corporation Balance Sheet June 30 Assets Cash $ 76,000 Accounts receivable 137,000 Inventory 86,100 Plant and equipment, net of depreciation 230,000 Total assets $ 529,100 Liabilities and Stockholders’ Equity Accounts payable $ 91,000 Common stock 312,000 Retained earnings 126,100 Total liabilities and stockholders’ equity $ 529,100 The company...
Cousins Corporation is a merchandising company that is preparing a master budget for the third quarter...
Cousins Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Cousins Corporation Balance Sheet June 30 Assets Cash $ 81,000 Accounts receivable 132,000 Inventory 56,250 Plant and equipment, net of depreciation 214,000 Total assets $ 483,250 Liabilities and Stockholders’ Equity Accounts payable $ 75,000 Common stock 346,000 Retained earnings 62,250 Total liabilities and stockholders’ equity $ 483,250 The company...
Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity...
Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity and the activity for the year in total. The master budget will be based on the following information: a. This will be the first year of operation for Okay Company. b. Budgeted unit sales by quarter for 2019 are projected as follows: First quarter 6,500, Second quarter 6,000, Third quarter 6,100 & Fourth quarter 6,250. First and second quarter 2020 budgeted sales units is...
To prepare a master budget for April, May, and June of 2019, management gathers the following...
To prepare a master budget for April, May, and June of 2019, management gathers the following information. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash $ 54,000 Accounts receivable 354,375 Raw materials inventory 100,495 Finished goods inventory 333,000 Total current assets 841,870 Equipment 628,000 Accumulated depreciation (164,000 ) Equipment, net 464,000 Total assets $ 1,305,870 Liabilities and Equity Accounts payable $ 212,195 Short-term notes payable 26,000 Total current liabilities 238,195 Long-term note payable 514,000 Total liabilities 752,195 Common...
Brothers Corporation is a merchandising company that is preparing a master budget for the third quarter...
Brothers Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: brothers Corporation Balance Sheet June 30 Assets Cash $ 81,000 Accounts receivable 132,000 Inventory 56,250 Plant and equipment, net of depreciation 214,000 Total assets $ 483,250 Liabilities and Stockholders’ Equity Accounts payable $ 75,000 Common stock 346,000 Retained earnings 62,250 Total liabilities and stockholders’ equity $ 483,250 The company...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Hamby Corporation Balance Sheet June 30 Assets Cash $ 76,000 Accounts receivable 137,000 Inventory 86,100 Plant and equipment, net of depreciation 230,000 Total assets $ 529,100 Liabilities and Stockholders’ Equity Accounts payable $ 91,000 Common stock 312,000 Retained earnings 126,100 Total liabilities and stockholders’ equity $ 529,100 The company...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Hamby Corporation Balance Sheet June 30 Assets Cash $ 84,000 Accounts receivable 144,000 Inventory 63,750 Plant and equipment, net of depreciation 223,000 Total assets $ 514,750 Liabilities and Stockholders’ Equity Accounts payable $ 84,000 Common stock 349,000 Retained earnings 81,750 Total liabilities and stockholders’ equity $ 514,750 The company...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Hamby Corporation Balance Sheet June 30 Assets Cash $ 71,000 Accounts receivable 131,000 Inventory 45,500 Plant and equipment, net of depreciation 215,000 Total assets $ 462,500 Liabilities and Stockholders’ Equity Accounts payable $ 76,000 Common stock 307,000 Retained earnings 79,500 Total liabilities and stockholders’ equity $ 462,500 The company...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter...
Hamby Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Hamby Corporation Balance Sheet June 30 Assets Cash $ 95,000 Accounts receivable 142,000 Inventory 54,000 Plant and equipment, net of depreciation 225,000 Total assets $ 516,000 Liabilities and Stockholders’ Equity Accounts payable $ 86,000 Common stock 332,000 Retained earnings 98,000 Total liabilities and stockholders’ equity $ 516,000 The company...