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 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
Step: 1
RIKKNEN MANUFACTURING INC Sales Budget Jan Feb Mar Total Expected Sales Unit 819500 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started