im sorry there are so many photos! all i need is help with the excel sheets including/especially the formulas. thank you!

Frenchies: Creating and using a Master Budget BACKGROUND Frenchies a medium sired regional bakery that is in providing order to grocery and convenience stores. Because of the popularity of its brand has also opened a small cafe for walk business In order to maintain its high quality standard. Frenchies produces only three products breakfast muffins, tresh bread and chocolate chips Athough bui has been good in the past few years, al contact with a large channedy wlowed to expand its brand out of the local region Growth has been high in the new contract went into effect Andy Grill, the chiet executive CEO and founder has arranged a meeting with a venture capital for next week. Hopeful the meeting wist in the sale of some of Frenchies stock and an opportunity to establish a significant ine of credit with the venture capitum. These extra funds, Andy can secure them should provide suficient money to meet Frenchies growth gets for the next few year. The venture capital masked Andy to provide a quarterly master budget for the year has become potomanancal statements at the meeting. They med specialist in Frenchiesings per a EPS cash flow from operations and prot mai dicating that good rumbers in these we will be sential for final approval in typical rangers Andy signed the task of creating the budget to Nicole Quanman who has been hired as Fandeco Snce this project is her first assignment Noole started taking appointments of the divisional managers to gather information for the budget and a team more about the company PARTE CREATING THE BUDGET MEETINGS WITH DIVISIONAL MANAGERS MEETING WITH THE SALES DEPARTMENT Walking down the way towards the otherager Noole read the rest for at arter which ended on December 31 2018 45.000 one-on packages of multis for 5.5 65.000 one-se Dacias 45 each and 15.000 one-domen e ofread for 15.25 When Niche motioned her in the seat s time for our mengde Who the day 90 Who knows the one you and the im saying good bye to everyone, Nicole with a sigh Theme to put everything done. And now I get to do me after could count on your support Tom som have to get there you are going to put something that Pealed wwe forting to come "Not to low how to be one but this year, the budget will prove to be a Jet Anyway, one way or another have to create one and your projected Do you have copy of state's Yere som Ground on the med Weve gently as he or "What do you want to know exactly Wel And the song hong both local and out now ay out who drop in He was thinking 58.00 for 152 153 youth "lagerty been yors Of wild some the first royThey www the hot but with the name se price Td say 30 percentut we have been up why industry was the Beery unge the udget and hand 11.12 AM SAN Questioning and enerow Nicole led. That sounds nothing Bed on what is the day indywing on wonly be about 10 perc Jeftlocked contact the sound in his charlestory by Our prices on any od Beoides 20 perc on the past we want to the change. Are you going to change Yesh but well be there to flow budget and proform Sanca mento show own. Werde for good wie ein want making and entert But my site wwe mawe wanden go Seeing the look on the dangerond. Nic wear the pron. A 10 percent result where pas 20 Deration Nicole and then she wong tuwoude beste mother word Weise 20 per your You just way out on that Hoople and mother that es yoyapata with row on our web of the 20 percent of the The following your crew Anongwe He Does that you yaybe some that the policy you made Tony htwho home to my wwww ave Siche NE ed Then Whe go wa 11.00 w SEME . 0 mm hovog MEETING WITH THE PRODUCTION DEPARTMENT tech matthew wth for so you G O Nicole sighed Then a great As they sat down, Nicolas de question Okay. Pined to know how much more keep on and Well, we cantep much in the way of fished goodson and Myles and read woundry out it weet tonto tong day that we mayor only about two days of inventory hands avoid shines of problems witheca "Okay and you make your states based on a day carer Pinodded Peas, Nico, dont ask obvious ques To sony, Let's talk about your party you take care of thing to do you? Yes We dedo become to run purchasing that have a manager do Aheadowrying twound her Well we want to dig Phi checked. fave to remember that one. Marta wille Okay let's take a Some day we have to produce a lot to meet our destroy try to keep 15 percent of the next Gate w on hand at all times rawat we get one for the coming year? Of cours de sedihad ready ted about the possibility of raising prices and his estimate of a 20 perdert in demand somatto Nicole consideredling Phat she was 20 percent drop worly mattu changed here. There would be time to get the extra ingredients ordered only top 10 percent and shoot want yone to think she had to per pressure "Good Can you give me samme of how long the to make each package of cookies and mutis Rydding? We don't really move each tomtom to fish We do them getaches I have ne how long each final packages Song Nico y went on "But, I can Sell you that one of mytherehe 12 de cookies 4 doren laves of bread in 15 minutes the balans the other has an hour so get the dough ready and be The baththorach product Yely to be things and post The packaging is the lowest They to be the cookies and more once to other hand once in any packages marketing cameo - 15 stopcage the two one couchage of to the package. The 15 mins we can cage court dans of in pants row without da pemer way 50 thout the show and the po 50 arte Per Thanthem Lee Yound of great for each Youth ambut by the correct white "Here they were just you out of the budgloot want Opetto Dont worrybel Niced down at the price het w TEAM CAM so Predproof. We pay the man hour the 800 hours and the PS 1650 an rect The more "Let me You are ingredienowe You must be the here about this to Header table on there they Juma dont of the building don't want Oops Bottegned down at the price wish I could buy my groceries the prices Pre chovember though that we build of That some great to located Torte me mure you do with Puteh Dodecay od Cookie when they go to the "W MEETING WITH THE ACCOUNTING DEPARTMENT med boks her own e Sheodor 180 out of the formato ed ore she wrote the eventuar atid bewege from the beginning and so Do yang Anything and Bows by wygodnion Teht We how you Saree Achod Bed W to get doing the budget to hodu DO NO Meet teodoro See you the wana OG Bard: where pe Bob said ething days wing wametre Ant 1210 wo Than A hthe Oy wang so you NO we yah bomen into con Doudoune Thay in se 300.000 ad Ant intento the wer www.google Her on the myths by me pe young How to do T w Bob, till me out our costs "Well, we don't really have that much in Vrable al costsWe give a one percent Comment Burst is that bed on profit or ne Sarah asked Total sales price. Sorry. I forgot to mention that the commission is paid both for business sales and les in the cal Aho, Ture's the table offling and administrative expenses Nicole took the paper "Thanks Olay. Sa me about our det Cahita Ei Le falling Alpenes Francis Balance Sheet As December 2016 100 Curry 100 Ass 000 Canan At OR 25.000 Cash SO 1000 Account Recette 01202 mes 2100 Raw w ory 2.00 35.000 361 Fished Goodsay Tomar SOM Total Cut Auss 20.00 1300 1800.00 Property. Plantando Land 57.000 Bulong 56700 Well at the end of you were Een 750 000 31.109 900 mortgage at contesto Accumulated Depe-Esimet 0.0001 payment durer is $20,000. Since Total PPE 130 000 mong the colors and of Each preso to pay a bunch orest 1954 and a bit of col To be 120.000 into the two parte veto muito the current mortgage by percent divide by Los gay Diede tyd Bob Lab Wel percent them in Accounts Payable 31 we make any payments were Mongea 1.109.943 by 4 St 111617 On Bob aid they should have Port Stocity ym, you should have a w Caton wery web 350 000 $150 000 was progresing dung uwih RE 337 Hringan had been one of trat Tutorial BU changes and seemed to be working out we the corrected to grow maybe he could Tiada Est 2014 bene dich standa Riget so our ret pent be made at the end of the quarter Wellent way $10.650 snerust and $3,300 Then that the value of the mortgage in the end 31.100 670 The's the oral 1.100.350,00 Thanh tra the eyes "Nicode 30.000 ch poming any of these years Sarded in the way we could get percent were O'The Last of how and comes the pret mistry Transpondente 'Ours 30 ans port tot een Op 10 percent VITIN 201 w Tyto where the Soyou that meets Teet our West Whey Crawfordele Th HS quan v H v of the nation www11000 wond grey met I wil 11.000 by 22 percent of the worsthaus been and Does under youth weby wory Andy and to as at your song and how about anything Need has my head output PART USING THE MASTER BUDGET MEETING OF THE SENIOR STAFF (TWO WEEKS LATER) Antend to wore and the Ancy Free Fotos So wewe to work with Showroom dan web Ines Tottenhough ng und Notund growth grob bodo do wa Way Youth ways wangu Antides of the When the could That som w port NEW Dibuted we Now French WOOOOOO home 1 person Perth wood SSC000 TO You Domo. Thered to win . per GON Twith Tango 20 de Our www Moment odore La bat I costs would be ind over more howed there would improve everything. Not Wooly my bou Look the in price is a good with the changes were to be the cash, but along to custo much bevative and get a great boost honary number and out fred Nicode segon "Anon opony, tefore Nicole com again would be to ne proosas calles ned our prices to 1575 formuffs. 5500 forint For by my ontwoolad to only a pencinin burrone with 7 percent growth of Nicoletowe. Jest would be more a 2 percento, not 12 percent. Then she ighed she couldn't win mo with the middle of a man with everyone ese watching and listening on brought up now they would wonder why he had brought it up before they might even think that she'd been trying to be bonus for And she would Sertanyaan enemy out of det her was arred. No she country anything here. She just have to let it go and hope that one of the there would work out Desides they may would be better they pulled o cater for Androne would Je bed and his was a constWe she said her two montesinde but not sure that we want to try all of them we change 100 chat we are just to be to give them with two gobete change for now the the web panther Wyma Taro Andy Why do you the numbers. how the change wotect of the which of the danges with most wond and me that changes and location That ww we got them movement proving the "And it anyone any errow The more improvement with our chances of gring AME CILO VILW Preded View 120 E Case Data + 5.000 Q1 os ot 09 35 Collection Information Manufacturing Information my AB D 14 16 11 Schedule of Cash Collections CO G LO De 19 Tech 0 PROTECTED VIEW Be carefron the Internacle Poc View H11 Production Budget 2 M 01 02 DT 00 mes Add ending wory Degengiventory Repro Frenchies: Creating and using a Master Budget BACKGROUND Frenchies a medium sired regional bakery that is in providing order to grocery and convenience stores. Because of the popularity of its brand has also opened a small cafe for walk business In order to maintain its high quality standard. Frenchies produces only three products breakfast muffins, tresh bread and chocolate chips Athough bui has been good in the past few years, al contact with a large channedy wlowed to expand its brand out of the local region Growth has been high in the new contract went into effect Andy Grill, the chiet executive CEO and founder has arranged a meeting with a venture capital for next week. Hopeful the meeting wist in the sale of some of Frenchies stock and an opportunity to establish a significant ine of credit with the venture capitum. These extra funds, Andy can secure them should provide suficient money to meet Frenchies growth gets for the next few year. The venture capital masked Andy to provide a quarterly master budget for the year has become potomanancal statements at the meeting. They med specialist in Frenchiesings per a EPS cash flow from operations and prot mai dicating that good rumbers in these we will be sential for final approval in typical rangers Andy signed the task of creating the budget to Nicole Quanman who has been hired as Fandeco Snce this project is her first assignment Noole started taking appointments of the divisional managers to gather information for the budget and a team more about the company PARTE CREATING THE BUDGET MEETINGS WITH DIVISIONAL MANAGERS MEETING WITH THE SALES DEPARTMENT Walking down the way towards the otherager Noole read the rest for at arter which ended on December 31 2018 45.000 one-on packages of multis for 5.5 65.000 one-se Dacias 45 each and 15.000 one-domen e ofread for 15.25 When Niche motioned her in the seat s time for our mengde Who the day 90 Who knows the one you and the im saying good bye to everyone, Nicole with a sigh Theme to put everything done. And now I get to do me after could count on your support Tom som have to get there you are going to put something that Pealed wwe forting to come "Not to low how to be one but this year, the budget will prove to be a Jet Anyway, one way or another have to create one and your projected Do you have copy of state's Yere som Ground on the med Weve gently as he or "What do you want to know exactly Wel And the song hong both local and out now ay out who drop in He was thinking 58.00 for 152 153 youth "lagerty been yors Of wild some the first royThey www the hot but with the name se price Td say 30 percentut we have been up why industry was the Beery unge the udget and hand 11.12 AM SAN Questioning and enerow Nicole led. That sounds nothing Bed on what is the day indywing on wonly be about 10 perc Jeftlocked contact the sound in his charlestory by Our prices on any od Beoides 20 perc on the past we want to the change. Are you going to change Yesh but well be there to flow budget and proform Sanca mento show own. Werde for good wie ein want making and entert But my site wwe mawe wanden go Seeing the look on the dangerond. Nic wear the pron. A 10 percent result where pas 20 Deration Nicole and then she wong tuwoude beste mother word Weise 20 per your You just way out on that Hoople and mother that es yoyapata with row on our web of the 20 percent of the The following your crew Anongwe He Does that you yaybe some that the policy you made Tony htwho home to my wwww ave Siche NE ed Then Whe go wa 11.00 w SEME . 0 mm hovog MEETING WITH THE PRODUCTION DEPARTMENT tech matthew wth for so you G O Nicole sighed Then a great As they sat down, Nicolas de question Okay. Pined to know how much more keep on and Well, we cantep much in the way of fished goodson and Myles and read woundry out it weet tonto tong day that we mayor only about two days of inventory hands avoid shines of problems witheca "Okay and you make your states based on a day carer Pinodded Peas, Nico, dont ask obvious ques To sony, Let's talk about your party you take care of thing to do you? Yes We dedo become to run purchasing that have a manager do Aheadowrying twound her Well we want to dig Phi checked. fave to remember that one. Marta wille Okay let's take a Some day we have to produce a lot to meet our destroy try to keep 15 percent of the next Gate w on hand at all times rawat we get one for the coming year? Of cours de sedihad ready ted about the possibility of raising prices and his estimate of a 20 perdert in demand somatto Nicole consideredling Phat she was 20 percent drop worly mattu changed here. There would be time to get the extra ingredients ordered only top 10 percent and shoot want yone to think she had to per pressure "Good Can you give me samme of how long the to make each package of cookies and mutis Rydding? We don't really move each tomtom to fish We do them getaches I have ne how long each final packages Song Nico y went on "But, I can Sell you that one of mytherehe 12 de cookies 4 doren laves of bread in 15 minutes the balans the other has an hour so get the dough ready and be The baththorach product Yely to be things and post The packaging is the lowest They to be the cookies and more once to other hand once in any packages marketing cameo - 15 stopcage the two one couchage of to the package. The 15 mins we can cage court dans of in pants row without da pemer way 50 thout the show and the po 50 arte Per Thanthem Lee Yound of great for each Youth ambut by the correct white "Here they were just you out of the budgloot want Opetto Dont worrybel Niced down at the price het w TEAM CAM so Predproof. We pay the man hour the 800 hours and the PS 1650 an rect The more "Let me You are ingredienowe You must be the here about this to Header table on there they Juma dont of the building don't want Oops Bottegned down at the price wish I could buy my groceries the prices Pre chovember though that we build of That some great to located Torte me mure you do with Puteh Dodecay od Cookie when they go to the "W MEETING WITH THE ACCOUNTING DEPARTMENT med boks her own e Sheodor 180 out of the formato ed ore she wrote the eventuar atid bewege from the beginning and so Do yang Anything and Bows by wygodnion Teht We how you Saree Achod Bed W to get doing the budget to hodu DO NO Meet teodoro See you the wana OG Bard: where pe Bob said ething days wing wametre Ant 1210 wo Than A hthe Oy wang so you NO we yah bomen into con Doudoune Thay in se 300.000 ad Ant intento the wer www.google Her on the myths by me pe young How to do T w Bob, till me out our costs "Well, we don't really have that much in Vrable al costsWe give a one percent Comment Burst is that bed on profit or ne Sarah asked Total sales price. Sorry. I forgot to mention that the commission is paid both for business sales and les in the cal Aho, Ture's the table offling and administrative expenses Nicole took the paper "Thanks Olay. Sa me about our det Cahita Ei Le falling Alpenes Francis Balance Sheet As December 2016 100 Curry 100 Ass 000 Canan At OR 25.000 Cash SO 1000 Account Recette 01202 mes 2100 Raw w ory 2.00 35.000 361 Fished Goodsay Tomar SOM Total Cut Auss 20.00 1300 1800.00 Property. Plantando Land 57.000 Bulong 56700 Well at the end of you were Een 750 000 31.109 900 mortgage at contesto Accumulated Depe-Esimet 0.0001 payment durer is $20,000. Since Total PPE 130 000 mong the colors and of Each preso to pay a bunch orest 1954 and a bit of col To be 120.000 into the two parte veto muito the current mortgage by percent divide by Los gay Diede tyd Bob Lab Wel percent them in Accounts Payable 31 we make any payments were Mongea 1.109.943 by 4 St 111617 On Bob aid they should have Port Stocity ym, you should have a w Caton wery web 350 000 $150 000 was progresing dung uwih RE 337 Hringan had been one of trat Tutorial BU changes and seemed to be working out we the corrected to grow maybe he could Tiada Est 2014 bene dich standa Riget so our ret pent be made at the end of the quarter Wellent way $10.650 snerust and $3,300 Then that the value of the mortgage in the end 31.100 670 The's the oral 1.100.350,00 Thanh tra the eyes "Nicode 30.000 ch poming any of these years Sarded in the way we could get percent were O'The Last of how and comes the pret mistry Transpondente 'Ours 30 ans port tot een Op 10 percent VITIN 201 w Tyto where the Soyou that meets Teet our West Whey Crawfordele Th HS quan v H v of the nation www11000 wond grey met I wil 11.000 by 22 percent of the worsthaus been and Does under youth weby wory Andy and to as at your song and how about anything Need has my head output PART USING THE MASTER BUDGET MEETING OF THE SENIOR STAFF (TWO WEEKS LATER) Antend to wore and the Ancy Free Fotos So wewe to work with Showroom dan web Ines Tottenhough ng und Notund growth grob bodo do wa Way Youth ways wangu Antides of the When the could That som w port NEW Dibuted we Now French WOOOOOO home 1 person Perth wood SSC000 TO You Domo. Thered to win . per GON Twith Tango 20 de Our www Moment odore La bat I costs would be ind over more howed there would improve everything. Not Wooly my bou Look the in price is a good with the changes were to be the cash, but along to custo much bevative and get a great boost honary number and out fred Nicode segon "Anon opony, tefore Nicole com again would be to ne proosas calles ned our prices to 1575 formuffs. 5500 forint For by my ontwoolad to only a pencinin burrone with 7 percent growth of Nicoletowe. Jest would be more a 2 percento, not 12 percent. Then she ighed she couldn't win mo with the middle of a man with everyone ese watching and listening on brought up now they would wonder why he had brought it up before they might even think that she'd been trying to be bonus for And she would Sertanyaan enemy out of det her was arred. No she country anything here. She just have to let it go and hope that one of the there would work out Desides they may would be better they pulled o cater for Androne would Je bed and his was a constWe she said her two montesinde but not sure that we want to try all of them we change 100 chat we are just to be to give them with two gobete change for now the the web panther Wyma Taro Andy Why do you the numbers. how the change wotect of the which of the danges with most wond and me that changes and location That ww we got them movement proving the "And it anyone any errow The more improvement with our chances of gring AME CILO VILW Preded View 120 E Case Data + 5.000 Q1 os ot 09 35 Collection Information Manufacturing Information my AB D 14 16 11 Schedule of Cash Collections CO G LO De 19 Tech 0 PROTECTED VIEW Be carefron the Internacle Poc View H11 Production Budget 2 M 01 02 DT 00 mes Add ending wory Degengiventory Repro