Question

Preparation of a complete master budget The management of Zigby Manufacturing prepared the following estimated balance...

Preparation of a complete master budget

The management of Zigby Manufacturing prepared the following estimated balance sheet for March, 2015:

ZIGBY MANUFACTURING

Estimated Balance Sheet

March 31, 2015

ASSETS

Cash..........................................................

$ 40,000

Accounts receivable................................

342,248

Raw materials inventory..........................

Finished goods inventory........................

98,500

   325,540

Total current assets.................................

806,288

Equipment................................................

$600,000

Less accumulated depreciation..............

150,000

     450,000

Total assets..............................................

$1,256,288

LIABILITIES AND EQUITY

Accounts payable....................................

$    200,500

Short-term notes payable....................................

12,000

Taxes payable..........................................

0

Total current liabilities.............................

212.500

Long-term note payable...........................

Common stock.........................................

$335,000

500,000

Retained earnings....................................

208,788

Total stockholders’ equity.......................

     543,788

Total liabilities and equity........................

$1,256,288

To prepare a master budget for April, May, and June of 2015, management gathers the following information:

  • Sales for March total 20,500 units. Forecasted sales in units are as follows: April, 20,500; May, 19,500; June, 20,000; and July, 20,500. Sales of 240,000 units are forecasted for the entire year. The product's selling price is $23.85 per unit and its total product cost is $19.85 per unit
  • Company policy calls for a given month's ending raw materials inventory to equal 50% of the next month's materials requirements. The March 31 raw materials inventory is 4,925 units, which complies with the policy. The expected June 30 ending raw materials inventory is 4,000 units. Raw materials cost $20 per unit. Each finished unit requires 0.50 units of raw materials.
  • Company policy calls for a given month's ending finished goods inventory to equal 80% of the next month's expected unit sales. The March 31 finished goods inventory is 16,400 units, which complies with the policy.
  • Each finished unit requires 0.50 hours of direct labor at a rate of $15 per hour.
  • Overhead is allocated based on direct labor hours. The predetermined variable overhead rate is $2.70 per direct labor hour. Depreciation of $20,000 per month is treated as fixed factory overhead.
  • Sales representatives' commissions are 8% of sales and are paid in the month of the sales. The sales manager's monthly salary is $3,000.
  • Monthly general and administrative expenses include $12,000 administrative salaries and 0.9% monthly interest on the long-term note payable.
  • The company expects 30% of sales to be for cash and the remaining 70% on credit. Receivables are collected in full in the month following the sale (none is collected in the month of the sale).
  • All raw materials purchases are on credit, and no payables arise from any other transactions. One month's raw materials purchases are fully paid in the next month.
  • The minimum ending cash balance for all months is $40,000. If necessary, the company borrows enough cash using a short-term note to reach the minimum. Short-term notes require an interest payment of 1% at each month-end (before any repayment). If the ending cash balance exceeds the minimum, the excess will be applied to repaying the short-term notes payable balance.
  • Dividends of $10,000 are to be declared and paid in May.
  • No cash payments for income taxes are to be made during the second calendar quarter. Income tax will be assessed at 35% in the quarter and paid in the third calendar quarter.
  • Equipment purchases of $130,000 are budgeted for the last day of June.

Required

Prepare the following budgets and other financial information as required. All budgets and other financial information should be prepared for the second calendar quarter, except as otherwise noted below. Round calculations up to the nearest whole dollar, except for the amount of cash sales, which should be rounded down to the nearest whole dollar.

  1. Budgeted income statement for the entire second quarter (not for each month separately).
  2. Budgeted balance sheet as of the end of the second calendar quarter.

Check  

(2) Units to produce: April, 19,700; May, 19,900

(3) Cost of raw materials purchases, April, $198,000

(5) Total overhead cost, May, $46,865

(8) Ending cash balance: April, $83,346; May, $124,295

(10) Budgeted total assets, June 30: $1,299,440

Homework Answers

Answer #1
Solution 9:
Zigby Manufacturing
Budgeted Income Statement
For Three Months Ended June 30, 2015
Particulars Amount
Sales $1,431,000.00
Cost of goods sold $1,191,000.00
Gross Profit $240,000.00
Expenses:
Selling Expenses $123,480.00
General and adminstrative expenses $49,500.00
Interest expense $120.00
Total Expenses $173,100.00
Income before taxes $66,900.00
Income tax expense (35%) $23,415.00
Net Income $43,485.00
Solution 10:
Zigby Manufacturing
Budgeted Balance Sheet
30-Jun
Particulars Amount
Assets:
Cash $40,000.00
Accounts receivables $333,900.00
Raw materials inventory $80,000.00
Finished goods inventory $325,540.00
Total Current Assets $779,440.00
Equipment, Gross $730,000.00
Accumulated Depreciation -$210,000.00
Equipment, net $520,000.00
Total Assets $1,299,440.00
Liabilities & Equity:
Liabilities:
Accounts payable $182,000.00
Short Term Notes Payable $16,752.00
Income taxes payable $23,415.00
Total Current Liabilities $222,167.00
Long term note payable $500,000.00
Total Liabilities $722,167.00
Stockholder's equity:
Common stock $335,000.00
Retained Earnings $242,273.00
Total stockholder's equity $577,273.00
Total Liabilities & Equity $1,299,440.00
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
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...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash $ 80,000 Accounts receivable 487,500 Raw materials inventory 93,390 Finished goods inventory 438,000 Total current assets 1,098,890 Equipment, gross 640,000 Accumulated depreciation (170,000 ) Equipment, net 470,000 Total assets $ 1,568,890 Liabilities and Equity Accounts payable $ 215,690 Short-term notes payable 32,000 Total current liabilities 247,690 Long-term note payable 520,000 Total liabilities 767,690 Common stock 355,000...
AGENDA: PROFIT PLANNING (BUDGETING) Building a master budget. 1. Sales budget 2. Production budget 3. Direct...
AGENDA: PROFIT PLANNING (BUDGETING) Building a master budget. 1. Sales budget 2. Production budget 3. Direct materials budget 4. Direct labor budget 5. Manufacturing overhead budget 6. Ending finished goods inventory budget 7. Selling and administrative expenses budget 8. Cash budget 9. Budgeted income statement 10. Budgeted balance sheet OVERVIEW OF BUDGETING A budget is a detailed plan for acquiring and using financial and other resources over a specified period. Budgeting involves two stages: • Planning: Developing objectives and preparing...
1 Master budget                                        
1 Master budget                                                                                                                                   60 points ABC Company requests you to prepare a budget for the third quarter ending September 30 2020. You are required to prepare the following budgets: Sales Sales receipt schedule Production Purchases Materials payment schedule Labor Overheads General admin and selling Capital Cash Sales Budget Budgeted sales of the company's product for the month of June was 28,000 units at $5/unit: It is anticipated that sales units will grow by 5% monthly from the previous month's...
Estimated sales for the secon dquarter will be as follows: April - 2,520 May  - 2,450 June...
Estimated sales for the secon dquarter will be as follows: April - 2,520 May  - 2,450 June - 2,350 Targe ending inventory of finished products is March 31 - 2030 April 30 - 2,220 May 31 - 2,110 June 30 - 2,360 2 units of material are required for each unit of finished product. Proudctino for July is 2,640 units to start building inventory for the fall sales period. Comapny policy is to have an inventory of raw materials at the...
14 Kyoto, Inc. predicts the following sales in units for the coming four months:                     April       May...
14 Kyoto, Inc. predicts the following sales in units for the coming four months:                     April       May      June    July Sales in units..........       240        280       300     240 Although each month's ending inventory of finished units should be 60% of the next month's sales, the March 31 finished goods inventory is only 100 units. A finished unit requires four pounds of raw material B. The March 31 raw materials inventory has 200 pounds of B. Each month's ending inventory of raw...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in units 240 280 300 240 Each month's ending Finished Goods Inventory in units should be 40% of the next month's sales. March 31 Finished Goods inventory is 96 units. A finished unit requires five pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 200 pounds of direct material B. Each month's...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in Units 410 450 470 410 Each month's ending Finished Goods Inventory should be 30% of the next month's sales. March 31 Finished Goods inventory is 123 units. A finished unit requires 5 pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 260 pounds of B. Each month's ending Raw Materials Inventory...
11.Cahuilla Corporation predicts the following sales in units for the coming four months: April May June...
11.Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in Units 360 400 420 360 Each month's ending Finished Goods Inventory should be 40% of the next month's sales. March 31 Finished Goods inventory is 144 units. A finished unit requires 5 pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 210 pounds of B. Each month's ending Raw Materials Inventory...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June...
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in Units 320 360 380 320 Each month's ending Finished Goods Inventory should be 40% of the next month's sales. March 31 Finished Goods inventory is 128 units. A finished unit requires 5 pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 280 pounds of B. Each month's ending Raw Materials Inventory...