Answered step by step
Verified Expert Solution
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
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
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