Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have been hired by the McClosky Corporation and they manufacture industrial dye. The company is preparing its 20X9 master budget and has presented you

You have been hired by the McClosky Corporation and they manufacture industrial dye. The company is preparing its 20X9 master budget and has presented you with the following information:

  1. The projected December 31, 20X8, balance sheet for the company is as follows:

Assets

Cash $ 6,080

Accounts Receivable 29,500

Raw Materials Inventory 1,000

Finished Goods Inventory 3,200

Prepaid Insurance 1,800

Building $ 350,000

Accum Depreciation (25,000) 325,000

Total Assets $ 366,580

Liabilities and Equity

Notes Payable $ 25,000

Accounts Payable 2,650

Dividends Payable 12,000

Total Liabilities $ 39,650

Common Stock $ 200,000

Paid-In Capital 40,000

Retained Earnings 86,930 326,930

Total Liabilities and

Stockholders Equity $ 366,580

  1. There is no beginning Work-in-Process Inventory. All work is completed in the period in which it is started. Raw Material Inventory at the beginning of the year consists of 1,100 gallons of direct material at a standard cost of $.90 per gallo$1,00n. There are 500 gallons of dye in Finished Goods Inventory at the beginning of the year carried at a standard cost of $6.28 per gallon; direct material, $.98, direct labor, $4.00; variable overhead $ .30; fixed overhead ,
  2. Accounts Payable relates to raw material and is paid 60 percent in the month of purchase and 40 percent in the month after purchase. No discounts are received for prompt payment.
  3. The dividend will be paid in January 20X9.
  4. A new piece of equipment will be purchased in March 20X9 and the cost is $12,000. Payment of 80 percent will be made in March and 20 percent in April. The equipment has a useful life of three years and will be placed in service on March 1.
  5. The note payable has a 12 percent interest rate; interest is paid at the end of each month. The principle of the note is repaid as cash is available to do so.
  6. The McClosky management team wishes to maintain a minimum cash balance of $5,500. Investments and borrowing are made in $100 amounts. (Even $100 amounts). Interest on any borrowings are expected to be 12 percent per year, and investments will earn 4 percent per year.
  7. The ending finished goods inventory should include 5 percent of next months sales. This will not be true at the beginning of 20X9 due to a miscalculation in sales for the month of December. The ending inventory of raw materials should be 5 percent of next months needs.
  8. Selling and administration costs per month are as follows: salaries $25,000; rent, $7,000 and utilities, $800. These costs are paid in cash as they are incurred.
  9. The companys tax rate is 20 percent.

Please note: You will be preparing a master budget for the first of 20X9 and the supporting schedules listed below:

Milestone 3:

  1. Budgeted Balance Sheet
  2. Cash Budget
  3. Budget Presentation and please address the following questions:
  1. The sales manager would like to increase the sales price by 10 next quarter, what will be the projected revenues be for the 2nd quarter.
  2. The production manager would like to purchase new equipment for next quarter due to the fact that their competitor has purchased equipment which cost $50,000. Will the company be able to make the purchase or will you need more information?
  3. The CEO feels that the cash budget is not necessary, please explain to the CEO why cash budgeting is important to the organization.
  4. Please explain the to the management team how a competitors actions can affect business planning.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing and Assurance Services

Authors: Timothy Louwers, Allen Blay, David Sinason, Jerry Strawser, Jay Thibodeau

7th edition

978-1259573286, 1259573281, 978-1260152166

More Books

Students also viewed these Accounting questions