Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help creating a combined cash budget and a pro forma balance sheet. attached is all the information 11 Unit sales (cases) 12 Mutiplied

I need help creating a combined cash budget and a pro forma balance sheet. attached is all the information
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed

11 Unit sales (cases) 12 Mutiplied by: Sales price per case 13 Total Sales Revenue 14 15 Cash Sales 60% 16 Credit Sales 25% 17 Credit Sales 15% 18 Total Sales Revenue 19 Grammy's Blueberry Muffins Sales Budget January-Quarter Month 20 21 22 23 34 25 Sales Revenue 26 Cash sales 60% 06 27 Credit Sales 25% month of sale 025 28 Credit Sales 15% next month of sale 015 25 Total cash collections 37 January February March Quarter $ 3022 28.41 S 85,839.91 $ 2630 8370 14022 28.41 $ 28.41 5 28.41 74,705.15 $237,749.85 $ 398.294.91 $1,503.95 $ 21,459.98 5 12.875.99 5 81.839.91 $ 44,82309 5 18,676.295 11,205.77 $ 74.705.15 $ 142,649.91 5 59,437.46 35662.48 5 238.976.95 $ 237,749.5 5 99.573.73 59,744.24 298.294.95 Grammy's Blueberry Muffins Cash Collections Budget January-Quarter Month January February $85.839.91 $74,705.15 March $237,749.85 $51,504 $44,823 $142,650 Quarter $398.294.91 $238,977 $21,460 $18.676 $40.136 $11.206 $11,206 $51,504 $66,283 $172.532 $290,319

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

Intermediate Accounting

Authors: James D. Stice, Earl K. Stice, Fred Skousen

16th Edition

324376375, 0324375743I, 978-0324376371, 9780324375749, 978-0324312140

More Books

Students also viewed these Accounting questions

Question

=+d) What components would you now say are in this series?

Answered: 1 week ago

Question

Explain the need for and importance of co-ordination?

Answered: 1 week ago

Question

Explain the contribution of Peter F. Drucker to Management .

Answered: 1 week ago

Question

What is meant by organisational theory ?

Answered: 1 week ago

Question

What is meant by decentralisation of authority ?

Answered: 1 week ago