Question: I do not have the same calculations for the projected sales section of all three (muffin, cookie, and etc). There are no calculations for it

I do not have the same calculations for the projected sales section of all three (muffin, cookie, and etc). There are no calculations for it and I'm wondering how you could help me break these calculations down

I do not have the same calculations for the projected sales section

Buns Bakery Basic Information For Year Ended December 31, Year 2 Case Data 10% = Signifies original case assumptio Sales Information: Estimated 16 drop: Estimated Growth: Estimated Additional Holiday Increase: Sales Cookies Bread Sales Numbers Trasposed for Copying 45.CCC 65.000 85.000 Muffins 201 2016 Current Your 03 04 01 Q2 36,CCC 52,000 68,000 37,BCC 10,800 47.828 43,758 45 946 37,BCC 54,600 71,40 Cookies 03 30,600 74,070 04 57,330 2015 04 2016 47.628 68, 796 85.364 52 000 54,600 Q1 Q2 57,330 68,796 63,206 66.367 43.758 63,20 82.65 Bread 45,946 16,367 86, THT 2015 2016 Sales Price/lie: 68.060 02 71,400 03 04 Q2 35.25 35.75 74,370 89,064 82,654 86,787 Collection Information: Credit Policy: Prior Year Current Year Cash Sales 10% Collection Schedule Transposed for Copying Credit Sales 91 Collection in Current Quarter 30% 37.046 40.546 22.51 Collection in Following Quarter Collection in and Quarter Collections from Last Year's Sales: Payments in Current Year Quarter PY . Soul PY . Received 02 04 3621,550 4180,450 $1,002,500 $406,013 8279 563 50 8370,925 ED 4586,463 $225.563 Manufacturing Information: Ending Inventory Coal Flaw Materials Coal Table 1 - Sales Budget Quarter Total 2016 Q1 02 03 04 2015 02 Muffins Budgeted Sales 36,000 37,800 39.690 47.628 161,118 43.758 45.946 Selling price per dozen $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 Total Sales Revenue from Muffins $216,000 $226,800 $238,140 $285,768 $966,708 $262,548 $275,676 Cookies Budgeted Sales 52,000 54,600 57,330 68,796 232,726 53.206 56.367 Selling price per dozen $5.25 $5.25 $5.25 $5.25 6.25 $5.25 15.25 Total Sales Revenue for Cookies $273,000 $286,650 $300,983 $361,179 $1,221,812 $331,832 $348,427 Bread Budgeted Sales 68,000 71,400 74,970 19.964 304,334 82.654 86.787 Selling price per loaf $5.75 $5.75 $5.75 $5.75 $5.75 $5.75 $5.75 Total Sales Revenue for Bread $391,000 $410,550 $431,078 $517,293 $1,749.921 $475,261 $499,025 Total Sales Revenue 5880,000 $924,000 5970,200 $1,164,240 $3,938.440 $1,069,640 $1,123,128 Table 2 - Schedule of Cash Collections Quarter Total Q1 02 03 04 Collections from last year $586,463 $225,561 $812.025 2889 $325,600 $356,400 $198,000 $880,000 5341,880 $374,220 $207,900 $924,000 $358,974 5392,931 $751,905 5430,769 $430.769 Total Cash Collections $912,063 6923,843 4 $1,031,600 $3.798.699

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!