Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
PLEASE SHOW CALCULATIONS/WORK FOR EACH ENTRY that way if I made a mistake I can see where I went wrong REQUIREMENTS 1. Cost of Goods
PLEASE SHOW CALCULATIONS/WORK FOR EACH ENTRY that way if I made a mistake I can see where I went wrong REQUIREMENTS 1. Cost of Goods Sold Budget (First quarter only) 2. Selling and Administrative Expenses Budget (Budget should be for the individual three (3) months of the first quarter of 2019. Include a quarterly total column on the rights side. Additional Details (Use proper rounding and show two (2) decimal places of accuracy on dollar amounts. Round up and show whole amounts on all other figures) (HINT: Excel provides functions for rounding: = ROUND(your formula ,2) = ROUND(your formula, 0) Balance Sheet Facts Sheet Production Budget Sale Budget Direct Materials Direct Labor Factory Overhead Bottas Manufacturing, Inc. Balance Sheet December 31, 2018 ASSETS Cash Marketable securities Accounts receivable Inventories: $25,711.00 20,000.00 565,844.43 Finished goods Work in process Direct materials $86,385.60 0.00 7,193.94 93,579.54 Total Current Assets 705,134.97 844,200.00 (318,600.00) Property, plant and equipment Less: Accumulated depreciation Total Property, Plant and Equipment 525,600.00 Total Assets $1,230,734.97 LIABILITIES AND STOCKHOLDERS EQUITY Accounts payable Income taxes payable Total Current Liabilities 5,755.15 0.00 5,755.15 436,000.00 441,755.15 Long-term notes payable Total Liabilities Common stock ($5.00 Par) Paid-in capital Retained earnings Total Stockholders Equity 475,000.00 100,000.00 213,979.82 788,979.82 Total Liabilities and Stockholders Equity $1,230,734.97 Total Liabilities and Stockholders Equity
PLEASE SHOW CALCULATIONS/WORK FOR EACH ENTRY that way if I made a mistake I can see where I went wrong
REQUIREMENTS
1. Cost of Goods Sold Budget
(First quarter only)
2. Selling and Administrative Expenses Budget
(Budget should be for the individual three (3) months of the first quarter of 2019. Include a quarterly total column on the rights side.
Additional Details
(Use proper rounding and show two (2) decimal places of accuracy on dollar amounts. Round up and show whole amounts on all other figures)
(HINT: Excel provides functions for rounding:
= ROUND(your formula ,2)
= ROUND(your formula, 0)
Balance Sheet
Facts Sheet
Production Budget
Sale Budget
Direct Materials
Direct Labor
Factory Overhead
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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