Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Everything in yellow needs to be answered. Some slots are filled, but i do not think I did it right so please DISREGARD those numbers.

Everything in yellow needs to be answered. Some slots are filled, but i do not think I did it right so please DISREGARD those numbers. also, PLEASE SHOW EXCEL FORUMALS. thank you!

image text in transcribed

image text in transcribed

\begin{tabular}{|l|r|l|} \hline Unit Price & $600 \\ \hline Variable Cost per Unit & $400 \\ \hline Monthly Fixed Costs & $80,000 \end{tabular} Revenues Sales Terms Breakdown \begin{tabular}{|l|l|} \hline Cash sales & 50.00% cash \\ \hline One month credit sales & 25.00% one month credit \\ \hline Two months credit sales & 25.00% two month credit \\ \hline \end{tabular} a) Before raising capital, the owner would like to know how the company's Cash Flow would look like for the next six months (January through June). Using the templates below, please prepare respective schedules and cash budget There was no data in the green box here so I assumed it was 600 Cost of Goods Sold Schedule b) Current forecasts are made based on the unit price of $1,000, The owner would like to know the dollar break-even for this assumption. He would also like to know to how unites should be sold to breakeven, and what the break-even in the "number of units" \begin{tabular}{|l|r|l|} \hline Unit Price & $600 \\ \hline Variable Cost per Unit & $400 \\ \hline Monthly Fixed Costs & $80,000 \end{tabular} Revenues Sales Terms Breakdown \begin{tabular}{|l|l|} \hline Cash sales & 50.00% cash \\ \hline One month credit sales & 25.00% one month credit \\ \hline Two months credit sales & 25.00% two month credit \\ \hline \end{tabular} a) Before raising capital, the owner would like to know how the company's Cash Flow would look like for the next six months (January through June). Using the templates below, please prepare respective schedules and cash budget There was no data in the green box here so I assumed it was 600 Cost of Goods Sold Schedule b) Current forecasts are made based on the unit price of $1,000, The owner would like to know the dollar break-even for this assumption. He would also like to know to how unites should be sold to breakeven, and what the break-even in the "number of units

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Crosson

9th Edition

B00650WABQ

More Books

Students also viewed these Accounting questions

Question

Identify the "always bar list" and the "presumption list."

Answered: 1 week ago

Question

Challenges Facing Todays Organizations?

Answered: 1 week ago