Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The statuettes sell for $700 each.Recent and forecasted sales (in units) are as follows: July (actual)3,500 August (actual)3,700 September (actual)3,800 October2,200 November2,800 December4,500 January1,000 February1,500

The statuettes sell for $700 each.Recent and forecasted sales (in units) are as follows:

July (actual)3,500

August (actual)3,700

September (actual)3,800

October2,200

November2,800

December4,500

January1,000

February1,500

March1,800

Inventories of finished goods on hand at the end of each month are to be equal to 50% of the following months budgeted sales.As of September 30th the company had 1,100 statuettes in inventory.

Each statuette requires 75 ounces of bronze, which the company purchases for $.45 per ounce.Rock Solid keeps an ending inventory of bronze at the end of each month equal to 75% of the next month's production needs.As of September 30th the company had 140,625 ounces of bronze on hand.

Purchases of raw materials are paid for as follows: 50% in the month of purchase and the remaining 50% in the following month. All sales are on credit, with no discount, and payable within 15 days. The company has found, however, that only 40% of a month's sales are collected by month-end. An additional 45% is collected in the month following, and the remaining 15% is collected in the second month following. Bad debts have been negligible.

Each statuette requires 15 hours to mould and polish.Employees who make the statuettes are paid $25 per hour and never work overtime (i.e. the company has enough casual workers that they can call in if additional work is required).

Manufacturing overhead includes all the costs of production other than direct materials and direct labour.The variable component is $45 per statuette in production and the fixed component is $117,000 per month (this amount includes depreciation of $22,000 per month on the furnaces, moulds and polishing equipment).Manufacturing overhead costs are allocated to statuettes on a per unit basis.

Rock Solid's monthly operating expenses are given below:

Variable:

Royalties paid to The Rock$50 per statuette sold

Fixed:

Wages & salaries$82,000

Utilities8,000

Insurance expired1,500

Depreciation11,500

Miscellaneous23,500

All operating expenses are paid during the month in cash, with the exception of the depreciation and insurance expenses.Due to the popularity of The Rock's movies the company is planning on producing different styles of statuettes with movie tie-ins.To accommodate the expected increase in demand the company will be purchasing a new blast furnace in October for $740,000 and some new moulds in November for $250,000.Rock Solid declares a dividend of $100,000 on the last day of each quarter which is then paid in the first month of the next quarter.

The balance sheet at September 30th is given below:

Assets

Cash$45,000

Accounts receivable1,984,500

Inventory, raw materials63,281

Inventory, finished goods 542,507

Unexpired insurance13,500

Fixed assets3,462,000

Accumulated depreciation(1,117,000)2,345,000

Total Assets$ 4,993,788

Liabilities and Shareholders' Equity

Accounts payable, purchases$ 44,297

Dividends payable100,000

Capital stock, no par2,000,000

Retained earnings2,848,491

Total liabilities and shareholders' equity$ 4,993,788

Management of Rock Solid requires a minimum ending cash balance each month of $20,000.The company can borrow money from its bank at 12% annual interest. All borrowing must be done at the beginning of a month, and repayments must be made at the end of a month. Repayments of principal must be in round $1,000 amounts. Borrowing is also in round $1,000 amounts. Interest is computed and paid at the end of each quarter on all loans outstanding during the quarter. Round all interest payments to the nearest whole dollar. Compute interest using whole months. The company wishes to use any excess cash to pay loans off as rapidly as possible.

REQUIRED:

  1. Sales Budget; Production Budget, Direct Materials Budget; Direct Labour Budget; Manufacturing Overhead Budget; and Sales and Administration Budget.
  2. Schedules of Expected Cash Collections and Expected Cash Disbursements for Material as well as a Cash Budget.
  3. Budgeted Income Statement for the quarter ending December 31st
  4. Budgeted Balance Sheet at December 31st.

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

Horngrens Financial And Managerial Accounting The Managerial Chapters

Authors: Tracie Miller Nobles, Brenda Mattison, Ella Mae Matsumura

6th Edition

0134486854, 978-0134486857

More Books

Students also viewed these Accounting questions

Question

How does the current landscape of global HRM impact HR planning?

Answered: 1 week ago

Question

What are some common types of consumer promotion?

Answered: 1 week ago

Question

Describe three types of learning discussed in the work of Koffka.

Answered: 1 week ago

Question

Describe ERP and how it can create efficiency within a business

Answered: 1 week ago

Question

8. What values do you want others to associate you with?

Answered: 1 week ago