I'm having a hard time figuring out what the formula inputs are for the cash collections budget. The final answers are $3,741,002 and $933,380. What are the formulations / inputs required to obtain these answers?

Below these pages I'm like 95% sure I have them correct.

 

 

Juliette's PastricSales Information:5 Quarterly Growth Assum0.056 Extra Holiday Sales:0.15MuffinsCookiesBread9 Prior Year:Q4450006500085000Dozen12 Current Year:13Q1=C10*0.8=D10*0.8=E10*0.814Q2=C13*(1+$D$5)=D13*(1+$D$5)=E13*(1+$D$5)15Q3=C14*(1+$D$5)=D14*(1+$D$5)=E14*(1+$D$5)16Q4=C15*1.2=D15*1.2=E15*1.21718 Next Year:19Q1=C15*(1.05)2=D15*(1.05)12=E15*(1.05)2201 Price per Dozen:65.255.52224 Collection Information2526 Historic Cash CollectionsCurrent collections froCash Sales:0.128Credit Sales:10.9Collected in Current YeCollected in current qtr.0.3LY SalesReceivedQQ2Collected in next qtr.0.45Q3802000621550=H30*E31=H30*E30Collected in following qtr.0.25Q41002500370925=H31*E30=H31*E31Total: =K30+K31EL30+L313435 Manufacturing Inform3637 Ending Inventory Goal:=2/904041AssumptionsSales Collections Production+Ready1 Accessibility: Good to go ABDEGHSales BudgetCurrent YearNext YearQ1Q2Q3Q4TotalQ1MuffinsBudgeted Sales36,000378003969047628161,11843758Price per Dozen6.006.006.006.00Total Revenue$216,000226,800238,140$285, 768 $966,7080 CookiesBudgeted Sales5200054600573306879623272663206Price per Dozen$5.25$5.25$5.255.25Total Revenue$ 273,000.00$ 286,650.00$ 300,982.50| $ 361,179.00 |$ 1,221,811.505Bread6Budgeted Sales68000714007497089964304334826547Price per Dozen$5.50 $5.50$5.50 $5.508Total Revenue$ 374,000.00$ 392,700.00 |$ 412,335.00 |$ 494,802.00 | $ 1,673,837.0090 Total Sales Revenue$863,000 $ 906 150 $951, 458 $ 1,141,749$ 3,862,3572 D28JxABCDEFGHSales BudgetCurrent YearNext YearQ1Q2Q3Q4TotalQ1MuffinsBudgeted Sales=Assumptions!C13=Assumptions!C14=Assumptions!C15=Assumptions!C16=SUM(C6:F6)=Assumptions!C19Price per Dozen=Assumptions!C21=Assumptions!C2=Assumptions!C21=Assumptions!C21Total Revenue=C6*C7=D6*D7=E6*E7=F6*F7=SUM(C8:F8)CookiesBudgeted Sales=Assumptions!D13=Assumptions!D14=Assumptions!D15=Assumptions!D16=C11+D11+E11+F11=Assumptions!D19Price per Dozen=Assumptions!D21=Assumptions!D21=Assumptions!D21=Assumptions!D21Total Revenue=C11*C12ED11*D12=E11*E12=F11 *F12=C13+D13+E13+F13BreadBudgeted Sales=Assumptions!E13=Assumptions!E14=Assumptions!E15=Assumptions!E16+D16+E16+F16=Assumptions!E19Price per Dozen=Assumptions!E21=Assumptions!E21=Assumptions!E21=Assumptions!E21Total Revenue=C16*C17=D16*D17=E16*E17=F16*F17=C18+D18+E18+F18Total Sales Revenue=C8+C13+C18=D8+D13+D18=E8+E13+E18=F8+F13+F18=C20+D20+E20+F20 ABCDEFGHCProduction BudgetCurrent YearNext YearQ1Q2Q3Q4TotalQ1MuffinsBudgeted Sales3600037800396904762816111843758plus Target Ending Inventory84088210589723753less Beginning Inventory80084088210583580Required Production36040378423986647542161290161290CookiesBudgeted Sales5200054600573306879623272663206plus Target Ending Inventory12131274152914055421less Beginning Inventory1 1561213127415295172Required Production52058546615758568672232975232975Bread8Budgeted Sales6800071400749708996430433482654plus Target Ending Inventory15871666199918377089less Beginning Inventory15111587166619996763Required Production68076714797530389802304660304660 ABCDEFGHProduction BucCurrent YearNext YearQ1Q2Q3Q4TotaQ1MuffinsBudgeted Sales=Assumptions!C13=Assumptions!C14=Assumptions!C15=Assumptions!C16 =C6+D6+E6+F6=Assumptions!C19plus Target Ending Inventory=Assumptions!D37*P=Assumptions!D37*P=Assumptions!D37*P=Assumptions!D37*P=C7+D7+87+F7less Beginning Inventory=C6*Assumptions!$0=D6*Assumptions!$0=E6*Assumptions!$D =F6*Assumptions!$D=C8+D8+E8+F8Required Production=C6+C7-C8=D6+D7-D8-E6+E7-E8=F6+F7-F8=C9+D9+E9+F9161290CookiesBudgeted Sales=Assumptions!D13 =Assumptions!D14 =Assumptions!D15 =Assumptions!D16 =SUM(C12:F12)=Assumptions!D19plus Target Ending Inventory=Assumptions!$D$37=Assumptions!$D$37=Assumptions!$D$37=Assumptions!$D$37=SUM(C13:F13)less Beginning Inventory=C12*Assumptions!$ =D12*Assumptions!$ =E12*Assumptions!$|=F12*Assumptions!$[=SUM(C14:F14)Required Production=C12+C13-C14ED12+D13-D14=E12+E13-E14=F12+F13-F14=C15+D15+E15+F151623297517 Bread18Budgeted Sales=Assumptions!E13 =Assumptions!E14=Assumptions!E15=Assumptions!E16 =SUM(C18:F18)=Assumptions!E19plus Target Ending Inventory=Assumptions!$D$37=Assumptions!$D$37=Assumptions!$D$37=Assumptions!$D$37=SUM(C19:F19)less Beginning Inventory=C18*Assumptions!$ =D18*Assumptions!$ =E18*Assumptions!$(=F18*Assumptions!$(=SUM(C20:F20)Required Production=C18+C19-C20=D18+D19-D20=E18+E19-E20=F18+F19-F20=SUM(C21:F21)304660 ABCDEFGHIJ1Cash Collections Budget2Collected This Year in QuarterAcct. Rec.4Q1Q2Q3Q4TotalBalance5 Prior year sales6516256115258020001002500306765067 This year's sales:$ 863,000.00$ 906,150.00$951,457.50$ 1,141,749.008Q1$258,900.00$ 388,350.00$215,750.00863,000.009Q2$ 271,845.00$ 407,767.50$ 226,537.50$906, 150.0010Q3$ 285,437.25$428, 155.88$ 713,593.1311Q4$342,524.70$ 342,524.7012Total Collected$ 258,900.00$ 660,195.00$ 908,954.75$997,218.08$ 2,825,267.8313$ 3,741,002.00$933,380.00141516 318vix fxABCDEFGHCash Collections BuCollected This Year in QuarterAcct. Rec.Q1Q3Q4TotalBalancePrior year sales=Assumptions!K32=Assumptions!L32=Assumptions!H30=Assumptions!H31=SUM(C5:F5)This year's sales:=Sales!C20=Sales!D20=Sales!E20=Sales!F20Q1=C7*Assumptions!E29=C7*Assumptions!E30=C7*Assumptions!E31=SUM(C8:F8)Q2=D7*Assumptions!E29=D7*Assumptions!E30=D7*Assumptions!E31=SUM(C9:F9)Q3=E7*Assumptions!E29=E7*Assumptions!E30=SUM(C10:F10)24=F7*Assumptions!E29=SUM(C11:F11)Total Collected=SUM(C8:C11)=SUM(D8:D11)=SUM(E8:E11)=SUM(F8:F11)=SUM(C12:F12)3741002933380