You have just been promoted to the position of controller at the Stanley Corporation. The company...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have just been promoted to the position of controller at the Stanley Corporation. The company is based in Moosic, PA. The company manufactures unfinished wooden book shelves. Projected sales in units for the first six months: January 20,000 February 22,000 March 26,000 April 31,000 May 37,000 June 22,000 The unit selling price is $240. The following data relates to production policies and manufacturing specifications: a Finished goods inventory on January 1 is 2,200 units. The desired ending inventory for each month is 20% of the next month's sales. b. There is only one direct material used - wood. Eight units are used for each bookcase. The unit cost is $7.25. Inventory policy dictates that sufficient materials be on hand at the beginning of the month to satisfy 25% of the next month's production needs. This is exactly the amount of material on hand on January 1. c. The direct labor used per unit of output is two hours. The average direct labor cost per hour is $32. d. Overhead each month is estimated using a flexible budget formula with activity measured a direct labor hours. Fixed Cost Component Supplies Power Maintenance Supervision Depreciation Other $22,000 $31,000 $85,000 $90,000 Variable Cost Component $1.00 .45 $1.00 $ 1.10 e. Monthly selling and administrative expenses are estimated using a flexible budget formula with activity measured in units sold. Fixed Cost Component $187,000 $40,000 $125,000 f. All sales and purchases are for cash. The cash balance on January 1 equals $ 85,000. The company wants to have an ending cash balance of at least $ 40,000. If a cash shortage develops, sufficient cash is borrowed to cover the shortage and provide the desired ending balance. Cash is borrowed in $1,000 increments and repaid the following month, as is the interest due. The interest rate is 8% per year. Salaries Commissions Depreciation Shipping Other 1. Sales budget 2. Production budget 3. Direct materials purchases budget 4. Direct labor budget 4. Direct 5. Overhead budget REQUIRED: Prepare a monthly operating budget, in good form, for each month in the first quarter of 2020 and provide a quarterly total (the company operates on a calendar year) with the following schedules: 6. Selling and administrative expense budget 7. Ending finished goods inventory budget 8. Cost of goods sold budget Variable Cost Component $ 2.00 9. Budgeted income statement (ignore income taxes) 10. Cash budget $18.00 $ 1.00 You have just been promoted to the position of controller at the Stanley Corporation. The company is based in Moosic, PA. The company manufactures unfinished wooden book shelves. Projected sales in units for the first six months: January 20,000 February 22,000 March 26,000 April 31,000 May 37,000 June 22,000 The unit selling price is $240. The following data relates to production policies and manufacturing specifications: a Finished goods inventory on January 1 is 2,200 units. The desired ending inventory for each month is 20% of the next month's sales. b. There is only one direct material used - wood. Eight units are used for each bookcase. The unit cost is $7.25. Inventory policy dictates that sufficient materials be on hand at the beginning of the month to satisfy 25% of the next month's production needs. This is exactly the amount of material on hand on January 1. c. The direct labor used per unit of output is two hours. The average direct labor cost per hour is $32. d. Overhead each month is estimated using a flexible budget formula with activity measured a direct labor hours. Fixed Cost Component Supplies Power Maintenance Supervision Depreciation Other $22,000 $31,000 $85,000 $90,000 Variable Cost Component $1.00 .45 $1.00 $ 1.10 e. Monthly selling and administrative expenses are estimated using a flexible budget formula with activity measured in units sold. Fixed Cost Component $187,000 $40,000 $125,000 f. All sales and purchases are for cash. The cash balance on January 1 equals $ 85,000. The company wants to have an ending cash balance of at least $ 40,000. If a cash shortage develops, sufficient cash is borrowed to cover the shortage and provide the desired ending balance. Cash is borrowed in $1,000 increments and repaid the following month, as is the interest due. The interest rate is 8% per year. Salaries Commissions Depreciation Shipping Other 1. Sales budget 2. Production budget 3. Direct materials purchases budget 4. Direct labor budget 4. Direct 5. Overhead budget REQUIRED: Prepare a monthly operating budget, in good form, for each month in the first quarter of 2020 and provide a quarterly total (the company operates on a calendar year) with the following schedules: 6. Selling and administrative expense budget 7. Ending finished goods inventory budget 8. Cost of goods sold budget Variable Cost Component $ 2.00 9. Budgeted income statement (ignore income taxes) 10. Cash budget $18.00 $ 1.00
Expert Answer:
Related Book For
OM operations management
ISBN: 978-1285451374
5th edition
Authors: David Alan Collier, James R. Evans
Posted Date:
Students also viewed these accounting questions
-
Assume that you have just been promoted to the position of in-charge accountant on the audit of Lancer Corporation, which manufactures and wholesalers consumer products. Lancers customer base is...
-
The Cardinal Company had a finished goods inventory of 55,000 units on January 1. Its projected sales for the next four months were: January - 200,000 units; February - 180,000 units; March - 210,000...
-
You have just been hired by EduRom Company, which was organized on January 2 of the current year. The company manufactures and sells a variety of educational DVDs for personal computers. It is your...
-
A six-lane freeway (three lanes in each direction) in a scenic area has a measured free-flow speed of 88.5 km/h. The peak-hour factor is 0.80, and there are 8% large trucks and buses and 6%...
-
The town council of Riverside met in December 2011. The council estimated revenues for 2012 to be $750,000 from property taxes and $150,000 from business licenses. The appropriations budget from the...
-
You can buy a machine for $100,000 that will produce a net income, after operating expenses, of $10,000 per year. If you plan to keep the machine for four years, what must the market (resale) value...
-
What is three octaves above \(\mathrm{G}_{2}\) ? State the requested note.
-
On June 1, 2019, Kris Storey established an interior decorating business, Eco-Centric Designs. During the month, Kris completed the following transactions related to the business: June 1. Kris...
-
Complete this question by entering your answers in the tabs below. Required A The company requires a 1 0 % return from its investments. Compute net present values using factors from Table B . 1 in...
-
Luna Company is an IFRS reporter. Luna Company acquired 100% of the voting stock of the AutoMania Group on January 1 of the current year for a total acquisition cost of $251,000. The trial balance of...
-
Suppose there exist two imaginary countries Yosemite and Everglades Their labor forces are each capable of supplying four million hours per week that can be used to produce shorts almonds or some...
-
Jaguar Plastics Company has been operating for three years. At December 31 of last year, the accounting records reflected the following: Cash $20,000 Accounts payable $20,000 Investments (short-term)...
-
How does a company really decide which investment method to apply? Explain the difference in accounting for consolidation before and subsequent to the date of aquisition.
-
Mainline Produce Corporation acquired all the outstanding common stock of Iceberg Lettuce Corporation for $30,000,000 in cash. The book values and fair values of Iceberg's assets and liabilities were...
-
Dr. Salor has decided to update his office while ordering medical supplies. Dr. Salor bought new furniture for $2300 and computers for $1600. He paid with cash for each item. Dr. Salor has difficulty...
-
Answer True or False:If a statement is not strictly true, then it is False.___ ___The yield to maturity on a bond is different than the IRR for zero coupon bonds.____ ____Payback is generally a...
-
Fairy chemical uses a standard cost system to account for the cost of its production of chemical X standards are 1.4 gallons of materials at $105 per gallon and 10 hours of labor a standard wage rate
-
Michelles trust is subject to 3.8% surtax on the lesser of the trusts net investment income or the excess of the trusts adjusted gross income over the $12,400 threshold (the highest trust tax rate)....
-
A manufacturers average work-in-process inventory for Part # 2934 is 750 parts. The workstation produces parts at the rate of 225 parts per day. What is the average time a part spends in this...
-
Describe the three types of value (supply) chain frameworks (i.e., Exhibits 2.1, 2.3 and 9.1) and which do you like the best. Why?
-
Explain why appointments are necessary for many professional services. List and explain some key issues and decisions that must be addressed in designing appointment systems.
-
Proper Documentation. Properly designed and utilized forms facilitate adherence to prescribed internal control structure policies and procedures. One such form might be a multicopy purchase order,...
-
Separation of Duties. The division of the following duties is meant to provide the best possible controls for the Ma Foi Magasin, a small wholesale store in Dijon, France. 1 V Assemble supporting...
-
Information and Communications. Hayes & Hu, Ltd, personal financial advisers in the Notting Hill district of London, has asked Joseph Smallman, Chartered Accountant (CA), to recommend a computer...
Study smarter with the SolutionInn App