Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Can someone help me finish this please? I really need it. Just need the last two pictures finished OPTIMA, INC. Additional information: Ending finished goods
Can someone help me finish this please? I really need it. Just need the last two pictures finished
OPTIMA, INC. Additional information: Ending finished goods inventory (percentage of the next quarter's sales) Ending raw materials inventory (percentage of the next quarter's production Evnontan numhar of framos sold in following quarters: 2nd Quarter 202175,000 Additional information: Cash on hand at January 1st, 2020 Percentage of sales in cash Percentage of credit sales collected during quarter of sale Percentage of credit sales collected in quarter following sale Percentage of direct material purchases paid in quarter purchased Percentage of direct material purchases paid in following quarter DepreciationincludedinquarterlyfixedmanufacturingoverheadDepreciationincludedinquarterlyfixedsellingandadministartiveexpenses$75,000$50,000 Amount expected to be paid for a piece of equipment (purchased in 4 th Quarter of 2020) Minimum cash balance required Borrowing increments Quarterly dividend payments $250,000 80% 50% 50% 80% 20% $75,000 $50,000 $750,000 $40,000 $1 $250,000 Regarding Inventory: Work-in-process has a zero beginning and ending balance. Direct Materials Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Purchased - Used = Ending) Finished Goods Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Produced Sold = Ending) Optima Company Balance Sheet 12/31/2019 \begin{tabular}{lr} \multicolumn{1}{c}{ Assets } & \\ \hline Cash & $250,000.00 \\ Finished goods invenotry & 650,000.00 \\ Direct materials inventory & 60,300.00 \\ Accounts receivable & 225,000.00 \\ Plant, Property, and equipment, net & 3,500,000.00 \\ \hline Total assets & 4,685,300.00 \\ \hline \end{tabular} Minimum cash balance required Borrowing increments Quarterly dividend payments Regarding Inventory: Work-in-process has a zero beginning and ending balance. Direct Materials Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Purchased - Used = Ending) Finished Goods Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Produced Sold = Ending) 3 Points 4 Point Budgeted Production (Units) Hours per unit Hours needed Cost per hour Total Cost Optima Company Direct Labor Budget \begin{tabular}{|rrrrrr|} \hline \multicolumn{5}{|c|}{ for the year ending December 31, 2020 } & \\ \hline Qtr. 1 & Qtr. 2 & Qtr. 3 & Qtr. 4 & Total \\ \hline 67,000 & 72,000 & 81,000 & 90,000 & 310.000 \\ 0.50 & 0.50 & 0.50 & 0.50 & \\ \hline 33,500.00 & 36,000.00 & 40,500.00 & 45,000.00 & 155,000.00 \\ 15,00 & 15.00 & & 15.00 & 15.00 \\ \hline$502,500.00 & $540,000.00 & $607,500.00 & $675,000.00 & $2,325,000.00 \\ \hline \end{tabular} 2 Points Optima Company Overhead Budget Budgeted hours Variable Rate. Budgeted VOH Budgeted FOH Total OH \begin{tabular}{|rrrrrr} \multicolumn{5}{c}{ for the year ending December 31, 2020 } & \\ \hline Qtr. 1 & Qtr.2 & Qtr. 3 & Qtr. 4 & Total \\ \hline 33,500 & 35,000 & 40,500 & 45,000 & 155.000 \\ 8.00 & 8.00 & 8.00 & 8.00 & \\ \hline 268,000.00 & 288,000.00 & 324,000,00 & 360,000.00 & 1,240,000.00 \\ \hline 275,000.00 & 275,000.00 & 275,000.00 & 275,000.00 & 1,100,000.00 \\ \hline$543,000.00 & $563,000.00 & $599,000.00 & $635,000.00 & $2,340,000.00 \\ \hline \end{tabular} Selling and Administrative Expenses Budget for the year ending Docember 31,2020 Budgeted Sales (Units) Variable Rate. Variable expenses \begin{tabular}{|rrrrrr|} \hline \multicolumn{2}{c}{ for the year ending December 31,2020} & Total \\ \hline Qtr. 1 & Qtr. 2 & Qtr. 3 & Qtr. 4 & \multicolumn{1}{l|}{ 2. Point } \\ \hline 65,000 & 70,000 & 75,000 & 90,000 & 300,000 \\ \hline 6.00 & 6.00 & 6.00 & 6.00 & \\ \hline 390,000.00 & 420,000.00 & 450,000.00 & 540,000.00 & 1,800,000.00 \\ \hline 200,000.00 & 200,000.00 & 200,000.00 & 200,000.00 & 800,000.00 \\ \hline \end{tabular} Optima Company Budgeted Cost Per Unit for the year ending December 31,2020 Unit Cost Budgeted Manufacturing Costs: Direct Materials Direct Labor Ovorhead: Variable Fixed Total Unit Costs Optima Company Cost of Goods Sold Budget for the year ending December 31, 2020 Budgeted Sales (Units) Budgeted Manufacturing Costs per unit Budgeted Cost of Goods Sold Cash Budget for the year ending December 31, 2020 Budgeted Cash Receipts Qtr.1Qtr.2Qtr.3Qtr.4Total Income Statement for the year ending December 31,2020 Sales Less: COGS Gross margin Less: S\&A Expenses Income before taxes Optima Company Retained Earnings Statement for the year ending December 31, 2020 Beginning Retained Earnings Add: Net Income(Loss) Deduct Dividends Ending Retained Earnings Cash Optima Company Accounts Receivable Balance Sheet Decmeber 31, 2020 Liabilities and Stockholders Equity Finished Goods Inventory Assets Direct Materials Inventory Plant, Property, and Equipment Accounts Payable Line of Credit Payable Total Assets Capital Stock Retained Eamings Total Liabilities \& Stockholders' 5 Budgeted Sales (Units) Unit Price Total Sales Optima Company Sales Budget Points for the year ending December 31, 2020 Optima Company Production Budget for the year ending December 31, 2020 Budgeted Sales (Units) Desired Ending Inventory (Units) Less: Beginning Inventory (Units) Budgeted Production (Units) \begin{tabular}{|rrrrr|} \hline \multicolumn{1}{|c|}{ Qtr. 1} & Qtr. 2 & Qtr. 3 & \multicolumn{1}{l|}{ Qtr. 4 } & \multicolumn{1}{l|}{ Total } \\ \hline 65,000 & 70,000 & 75,000 & 90,000 & 90,000 \\ \hline 28,000 & 30,000 & 36,000 & 36,000 & 30,000 \\ \hline(26,000) & (28,000) & (30,000) & (36,000) & (36,000) \\ \hline 67,000 & 72,000 & 81,000 & 90,000 & 84,000 \\ \hline \end{tabular} Budgeted Production (Units) Materials per unit Production needs Optima Company Direct Materials Purchases Budget for the year ending December 31, 2020 Desired ending Inventory \begin{tabular}{|r|rrrr} \hline \multicolumn{1}{c}{ Qtr.1 } & Qtr. 2 & Qtr. 3 & Qtr. 4 & \multicolumn{1}{l}{ Total } \\ \hline 67,000 & 72,000 & 81,000 & 90,000 & 84,000 \\ \hline 3 & 3 & 3 & 3 & 3 \\ \hline 201,000 & 216,000 & 243,000 & 270,000 & 252,000 \\ 64,800 & 72,900 & 81,000 & 75,600 & \\ \hline \end{tabular} Budgeted Production (Units) \begin{tabular}{|rrrrr|} \hline Qtr. 1 & Qtr. 2 & Qtr. 3 & Qtr. 4 & Total \\ \hline 67,000 & 72,000 & 81,000 & 90,000 & 84,000 \\ \hline 3 & 3 & 3 & 3 & 3 \\ \hline 201,000 & 216,000 & 243,000 & 270,000 & 252,000 \\ \hline 64,800 & 72,900 & 81,000 & 75,600 & \\ \hline(60,300) & (64,800) & (72,900) & (81,000) & \\ \hline 205,500 & 224,100 & 251,100 & 264,600 & \\ \hline 2.00 & 2.00 & 2.00 & 2.00 & \\ \hline$411,000.00 & $448,200.00 & $502,200.00 & $529,200.00 & \\ \hline \end{tabular} Optima Company Direct Labor Budget for the year ending December 31, 2020 Budgeted Production (Units) Hours per unit Hours needed Cost per hour Total Cost \begin{tabular}{|rrrrr|} \hline \multicolumn{1}{|c|}{ Qtr. 1} & Qtr. 2 & Qtr. 3 & \multicolumn{1}{|c|}{ Qtr. 4} & \multicolumn{1}{l|}{ Total } \\ \hline 67,000 & 72,000 & 81,000 & 90,000 & 310,000 \\ \hline 0.50 & 0.50 & 0.50 & 0.50 & \\ \hline 33,500.00 & 36,000.00 & 40,500.00 & 45,000.00 & 155,000.00 \\ \hline 15.00 & 15,00 & & 15.00 & 15.00 \\ \hline$502,500.00 & $540,000.00 & $607,500.00 & $675,000.00 & $2,325,000.00 \\ \hline \end{tabular} Optima Company Overhead Budget for the year ending December 31, 2020 Budgeted hours Variable Rate Budgeted VOH Budaeted FOH \begin{tabular}{|rrrrr|} \hline Qtr. 1 & \multicolumn{1}{|c|}{ Qtr. 2 } & \multicolumn{1}{c|}{ Qtr. 3} & Qtr. 4 & Total \\ \hline 33,500 & 36,000 & 40,500 & 45,000 & 155,000 \\ \hline 8.00 & 8.00 & 8.00 & 8.00 & \\ \hline 268,000.00 & 288,000.00 & 324,000.00 & 360,000.00 & 1,240,000.00 \\ \hline 275.000.00 & 275.000.00 & 275.000.00 & 275.000.00 & 1.100.000.00 \\ \hline \end{tabular} Optima Company Cost of Goods Sold Budget for the year ending December 31, 2020 \begin{tabular}{l|llll} Qtr. 1 & Qtr. 2 & Qtr. 3 & Qtr. 4 & Total \end{tabular} Budgeted Sales (Units) Budgeted Manufacturing Costs per unit Budgeted Cost of Goods Sold Optima Company Cash Budget for the year ending December 31, 2020 Budgoted Cash Receipts Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Total Budgeted Sales Revenue Cash Collections Credit Collections (Current Month) Credit Collections (Following Month) Budgeted Cash Receipts Budgeted Cash Disbursements Budgeted Raw Materials Purchases \begin{tabular}{|c|c|c|c|c|} \hline Qtr. 1 & Qtr. 2 & Qtr. 3 & Qtr. 4 & Total \\ \hline 411,000.00 & 448,200.00 & 502,200.00 & 529,200.00 & 1,891,200.00 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|r||r|} \hline Raw Materials Payments (Current Month) & 329,280.00 & 358,560.00 & 401,760.00 & 423,360.00 & 1,512,960.00 \\ \hline Raw Materials Payments (Following Month) & 90,000.00 & 82,320.00 & 89,640.00 & 100,440.00 & 362,400.00 \\ \hline Direct Labor & 502,500.00 & 540,000.00 & 607,500.00 & 675,000.00 & 2,325,000.00 \\ \hline Manufacturing Overhead & 543,000,00 & 563,000.00 & 599,000.00 & 635,000.00 & 2,340,000.00 \\ \hline less: Depreciation & (75,000.00) & (75,000.00) & (75,000.00) & (75,000.00) & (300,000.00) \\ \hline Selling and Administrative Expenses & 590,000.00 & 620,000.00 & 650,000.00 & 740,000.00 & 2,600,000.00 \\ \hline \end{tabular}
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e75fd24c9d_924669e75fca1a6d.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e75fe0d34d_925669e75fd7f896.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e75fecc604_926669e75fe4b4d6.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e75ff73952_927669e75ff0d2c8.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e760010eb5_927669e75ffa985a.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e7600a4d42_928669e760047d67.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e76014b49d_928669e7600dd67d.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e7601eb2ea_929669e760186cc6.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e7602a3461_930669e76023ea54.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e76033b4ce_930669e7602d2b57.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started