Answered step by step
Verified Expert Solution
Question
1 Approved Answer
HELP!!! PLEASE HELP!!! I need to solve all the orange spaces, the blue is the info i was given. i just am confused on the
HELP!!! PLEASE HELP!!! I need to solve all the orange spaces, the blue is the info i was given. i just am confused on the formulas and need guidance, please send help
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: 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 Depreciation included in quarterly fixed manufacturing overhead Depreciation included in quarterly fixed selling and administartive expenses 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 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}{lrr} \multicolumn{1}{l}{ 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} Liabilities and Stockholders' Equity Accounts Payable Capital Stock Retained earnings Total liabilities and stockholders equity Optima Company Budgeted Cost Per Unit for the year ending December 31, 2020 Budgeted Manufacturing Costs: Unit Cost Direct Materials Direct Labor Overhead: 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 \begin{tabular}{|rrrrrr|} \hline \multicolumn{1}{|c}{ Qtr. 1} & Qtr. 2 & \multicolumn{1}{c}{ Qtr. 3} & \multicolumn{1}{c|}{ Qtr. 4 } & \multicolumn{1}{c|}{ Total } \\ \hline 65,000 & 70,000 & 75,000 & 90,000 & 300,000 \\ \hline 21.05 & 21.05 & 21.05 & 21.05 & 21.05 \\ \hline$1,368,250.00 & $1,473,500,00 & $1,578,750.00 & $1,894,500.00 & $6,315,000,00 \\ \hline \end{tabular} Optima Company Cash Budget for the year ending December 31,2020 Optima Company Income Statement for the year ending December 31, 2020 Sales 2 Points -ess: 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 2 Points Add: Net income(Loss) Deduct Dividends Ending Retained Earnings Optima Company Balance Sheet Decmeber 31, 2020 Assets Liabilities and Stockholders Equity 4 Points Cash Accounts Payable Accounts Receivable Line of Credit Payable Finished Goods inventory Capital Stock Total Direct Materials inventory Retained Earnings 40 Points Plant, Property, and Equipment Total Assets Total Liabilites \& Stockholders' E 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