Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can anyone please help me finish this? I really need to pass this class OPTIMA, INC. Additional information: Ending finished goods inventory (percentage of the
Can anyone please help me finish this? I really need to pass this class
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 Expected number of frames sold in following quarters: 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 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) Optima Company Sales Budget Budgeted Sales (Units) Unit Price Total Sales Optima Company Production Budget Budgeted Sales (Units) Desired Ending Inventory (Units) Less: Beginning Inventory (Units) Budgeted Production (Units) for the year ending December 31, 2020 Points \begin{tabular}{|rrrrr|} \hline \multicolumn{2}{|c|}{ for the year ending December 31, 2020 } & \multicolumn{1}{c|}{ Total } \\ \hline Qtr. 1 & Qtr. 2 & Qtr. 3 & Qtr. 4 & \multicolumn{1}{c|}{ 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 Direct Materials Purchases Budget for the year ending December 31, 2020 Desired ending Inventory \begin{tabular}{|r|rrrr} \hline 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}{|r|r|r|r|r|} \hline \multicolumn{1}{|c|}{ Qtr. 1} & \multicolumn{1}{|c|}{ Qtr. 2 } & \multicolumn{1}{|c|}{ Qtr. 3 } & \multicolumn{1}{|c|}{ Qtr. 4 } & \multicolumn{1}{|c|}{ 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} & \multicolumn{1}{l|}{ 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} Budgoted Manufacturing Costs: Direct Materials Direct Labor Overhead: Variable Fixed Total Unit Costs Optima Company Budgeted Cost Per Unit for the year ending December 31,2020 Unit Cost Optima Company Cost of Goods Sold Budget for the year ending December 31,2020 Budgeted Sales (Units) \begin{tabular}{l|l|lll} \hline Qtr. 1 & Qtr. 2 & Qtr. 3 & Qtr. 4 & Total \end{tabular} + Instructions * Given * Budget * Optima Company Cost of Goods Sold Budget for the year ending December 31, 2020 Qtr.1Qtr.2Qtr.3Qtr.4Total Budgetod 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|l|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} Optima Company Income Statement for the year ending December 31, 2020 Sales Less: coGs Gross margin 132 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 Optima Company Balance Sheet Decmeber 31,2020 Assets Liabilities and Stockholders Equity Cash 40,000.00 Accounts Payable Accounts Receivable Line of Credit Payable Finished Goods Inventory Capital Stock Direct Materials inventory Retained Earnings Plant, Property, and Equipment Step by Step Solution
There are 3 Steps involved in it
Step: 1
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