HELP!!! PLEASE HELP!!! I need to solve all the orange spaces, the blue is the...

90.2K

Verified Solution

Question

Accounting

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
image
image
image
image
image
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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students