Question

In: Accounting

Acct 552 Course Project (Master Budget Preparation) You have been hired by the McClosky Corporation and...

Acct 552 Course Project

(Master Budget Preparation)

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

Other Information that is being provided to you:

  1. The Accounts Receivable balance at 12/31/20X8 represents the balances of November and December credit sales. Sales were $90,000 and $85,000 respectively.
  2. Estimated sales in gallons of dye for January through May 20X9 are as follows:

    January                                                9,000

    February                                           11,000

   March                                                 16,000

   April                                                    14,000

   May                                                     13,000

   June                                                     12,000

Each gallon of dye sells for $ 15

  1. The collection pattern for accounts receivable is as follows: 70 percent in the month of sale, 20 percent in the first month after the sale, and 10 percent in the second month after the sale. McClosky does not provide cash discounts and they are not expecting any bad debts.
  2. Each gallon of dye has the following standard quantities and costs for direct material and direct labor:

1.4 gallons of direct material (some evaporation takes place during processing) X $.90 per gallon                                                               $ 1.26

0.5 direct labor X $ 8 per hour                                                                4.00

  1. Variable overhead is applied to the product on a machine-hour basis. Processing one gallon of dye takes five hours of machine time. The variable overhead is $0.08 per machine hour. Variable overhead consists of utility costs. Total annual fixed overhead is $150,000; it is applied at $ 1 per gallon based on expected annual capacity of 150,000 gallons. Fixed overhead per year is made up of the following costs:

     Salaries                                         $ 110,000

     Utilities                                               15,000

   Insurance                                             1,800

     Depreciation-factory                        23,200

Fixed overhead is incurred evenly throughout the year.

  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 gallon. 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 , $1,00
  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 month’s 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 month’s 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 company’s tax rate is 20 percent.

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

Requirements:

Milestone 1:

Please prepare the following budgets:

  1. Sales Budget
  2. Production Budget
  3. Purchases Budget

Please submit Milestone 1 at the end of Week 6.

Milestone 2:

Please prepare the following budgets:

  1. Labor Budget
  2. Variable Overhead Budget
  3. Fixed Overhead Budget
  4. Budgeted Cost of Goods Manufactured
  5. Budgeted Income Statement

Please submit Milestone 2 at the end of Week 7.

Milestone 3:

  1. Budgeted Balance Sheet
  1. Cash Budget
  2. 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 competitor’s actions can affect business planning.

Please submit Milestone 3 at the end of Week 8.

Solutions

Expert Solution


Related Solutions

Course Project: Master Budget Milo-Freeze Company Description This course contains a Course Project, where you will...
Course Project: Master Budget Milo-Freeze Company Description This course contains a Course Project, where you will be required to submit the final completed project at the end of Week 7. Using the budgeting assumptions provided for Milo-Freeze Company, you will prepare a sales budget, a production budget, a direct materials budget and a schedule of expected cash payments for purchases of materials. An Excel template will be provided and required to use to complete and submit. Budgeting Assumptions Milo-Freeze Company...
Part C: Master Budget with Supporting Schedules You have just been hired as a new management...
Part C: Master Budget with Supporting Schedules You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming...
You have been engaged as a consultant to design a master budget model and then to...
You have been engaged as a consultant to design a master budget model and then to assist Helping Hand Corp. in making some management decisions based on that master budget. Helping Hand is a small, rapidly growing wholesaler of consumer electronic products. The company’s main product lines are small kitchen appliances and power tools. The marketing manager has recently completed a sales forecast. She believes the company’s sales will increase by 1 percent each month over the previous month’s sales...
Ellis Corporation prepares its master budget on a quarterly basis. The following data have been assembled...
Ellis Corporation prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the third quarter of 2019: As of June 30, 2019 (the end of the prior quarter), the company's general ledger showed the following account balances:                                                                                              Debits             Credits       Cash                                                                             $25,000                                    Accounts Receivable          75,000       Inventory                                                                       60,000       Plant and Equip (net)                                                    190,000       Accounts Payable                                                                                 $60,000       Short-term Notes Payable                                                                       25,000      ...
Master Budget Project Okay Company is preparing to build its master budget. The budget will detail...
Master Budget Project 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 2017 are projected as follows: First quarter 6,300, Second quarter 6,100, Third quarter 6,100 & Fourth quarter 6,450. First and second quarter 2018 budgeted...
Master Budget Project Okay Company is preparing to build its master budget. The budget will detail...
Master Budget Project 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: This will be the first year of operation for Okay Company. Budgeted unit sales by quarter for 2017 are projected as follows: First quarter 6,300, Second quarter 6,100, Third quarter 6,100 & Fourth quarter 6,450. First and second quarter 2018 budgeted sales units...
You have been hired to manage a new software development project. The project will use OO...
You have been hired to manage a new software development project. The project will use OO design. As part of your job, you must establish an evaluation procedure for the UML Class Diagrams that your developers produce. Discuss how you approach this task.
Congratulations! You have just been hired as a senior IT portfolio and project manager at a...
Congratulations! You have just been hired as a senior IT portfolio and project manager at a traditional large finance company. The company is looking to invest in new financial products and services. You are now in charge of all new strategic IT projects to enable and support these new products and services. In your team, you have many subject matter experts, analysts, product and project managers, either directly or indirectly working for you . (a) Describe all areas of the...
Budget Preparation Westport Company is preparing its master budget for May. Use the estimates provided to...
Budget Preparation Westport Company is preparing its master budget for May. Use the estimates provided to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.) a. What should total sales revenue be if territories E and W estimate sales of 50,000 and 100,000 units, respectively, and the unit selling price is $35? b. If the beginning finished goods inventory is an estimated 6,000 units and the desired ending inventory is...
Budget Preparation Collins Company is preparing its master budget for April. Use the given estimates to...
Budget Preparation Collins Company is preparing its master budget for April. Use the given estimates to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.) a. What should total sales revenue be if territories A and B estimate sales of 10,000 and 12,000 units, respectively, and the unit selling price is $40? $Answer b. If the beginning finished goods inventory is an estimated 2,000 units and the desired ending inventory...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT