Need help on budgeting assignment on Excel?

Thing to do are do a budgeting on Excel on Fictonal Restaurant budget and answer a question on Excel on tap analysis.

 

Intro: Could you imagine working in an establishment that didn't even use budgets? Not having to do sales or cost projections? You would think that might be a dreamy setting. The problem here is there wouldn't be a figure for profit margin or percentages. How would you plan or keep spending in check? A set up like this is not at all optimal for success in the long run.

The other side of the coin is a business where the controls are too tight. Being so specific that you would be required to project all revenues for every single day of the upcoming year. It could help you learn, though, and be able to give firm explanations for shortfalls or overages, but is quite alot of work and hard to predict such tight confines as one day out of 365.

The best scenario is somewhere in between the two. Using history and future projections in an educated guessing game are key to making the budget work for you. You should keep this in mind when working on the Budget Worksheet assignment in this folder.

Budget writing assignment : This assignment may seem a bit advanced, but as the directions point out, quite a bit of this is based on assumptions and there are no real wrong answers. Read the instructions carefully and follow ALL tabs at the bottom of the spreadsheet. You are to only do the figures for February. You must simply fill in the dollar and percentage column with numbers you feel work within the information given including January's figures, and give answers to the analysis questions.

You should see the following tabs: "Instructions", "Sample Budget", "Fictonal Restaurant Budget" and, finally "Analysis".

• 1497942614-2015 Budget exercise1.xlsx

SuperTutor

(15)

Status NEW Posted 20 Jun 2017 07:06 AM My Price 7.00

-----------

Attachments

file 1497942617-Solutions file.docx preview (56 words )

S-----------olu-----------tio-----------ns -----------fil-----------e -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly----------- on-----------lin-----------e a-----------nd -----------giv-----------e y-----------ou -----------exa-----------ct -----------fil-----------e a-----------nd -----------the----------- sa-----------me -----------fil-----------e i-----------s a-----------lso----------- se-----------nt -----------to -----------you-----------r e-----------mai-----------l t-----------hat----------- is----------- re-----------gis-----------ter-----------ed -----------onÂ----------- th-----------is -----------web-----------sit-----------e. ----------- H-----------YPE-----------RLI-----------NK -----------&qu-----------ot;-----------htt-----------p:/-----------/wo-----------rkb-----------ank-----------247-----------.co-----------m/&-----------quo-----------t; -----------\t -----------&qu-----------ot;-----------_bl-----------ank-----------&qu-----------ot;----------- -----------Tha-----------nk -----------you----------- -----------

Not Rated(0)

• Buy Answer