Question: Prepare, in good form, a Master Budget which includes the following: 1) Sales Budget 2) Production Budget 3) Direct Materials Budget 4) Direct Labor Budget

Prepare, in good form, a Master Budget which includes the following:

1) Sales Budget

2) Production Budget

3) Direct Materials Budget

4) Direct Labor Budget

5) Manufacturing Overhead Budget

6) Selling and Administrative Expense Budget

7) Schedule of Expected Collections from Customers

8) Schedule of Expected Payments for Direct Materials

9) Cash Budget

10) Total and Per Unit Cost of Goods Sold (break-down by DM/DL/MOH)

11) Ending Inventory amounts (show calculations)

All budgets should be for the individual three months of the first quarter of 2016.

Include a quarterly total column on the right side. (except for #10 and #11)

Each budget/requirement should be in a separate notebook within one spreadsheet.

All pages should be in portrait format using the same font type and size.

Please staple the printed copy in the upper left corner.

Do not put the sheets into plastic or a binder.

Treat this as you would any other professional document you are presenting to a client or employer.

Use proper rounding and show two (2) decimal places of accuracy on dollar amounts.

Round up and show whole amounts on all other figures

RIKKNEN MANUFACTURING, INC. BALANCE SHEET DECEMBER 31, 2015 Cash Marketable Securities Accounts

Receivable Interest Receivable Inventories: Raw Materials Work in Process Finished Goods Total

RIKKNEN MANUFACTURING, INC. BALANCE SHEET DECEMBER 31, 2015 Cash Marketable Securities Accounts Receivable Interest Receivable Inventories: Raw Materials Work in Process Finished Goods Total Current Assets Total Assets ASSETS Property, Plant and Equipment Less: Accumulated Depreciation Total Property, Plant and Equipment $ 6,121.28 97,163.67 801,990.00 (302,670.00) $ 30,853.00 20,000.00 689,217.00 103,284.95 843,354.95 499,320.00 $ 1,342,674.95 LIABILITIES AND STOCKHOLDERS EQUITY Accounts Payable Interest Payable Income Tax Payable Short Term Borrowings Total Current Liabilities Long-Term Notes Payable Total Liabilities Common Stock ($5.00 Par) Paid in Capital in Excess of Par Retained Earnings Total Stockholders Equity $ 100,000.00 475,000.00 323,959.71 Total Liabilities and Stockholders Equity $ 7,715.24 7,715.24 436,000.00 443,715.24 898,959.71 $ 1,342,674.95

Step by Step Solution

3.51 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Creating a comprehensive Master Budget involves several steps Lets break it down stepbystep Well start with the Sales Budget and work through each required component 1 Sales Budget Step 1 Collect Info... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!