Basic Assumptions for Master Budget 2015
I need some help on a question. The spreadsheet is attached, but basically:
Â
-There are a list of assumptions on tab one (yellow highlighted portion) that I need help with calculating the changes. (the data you need is in the related data section)
Sales volume will increase by 15%Â over the prior year.
Sales prices will increase by 5%Â over the prior year.
Average unit cost of an automobile will decrease by 2%
Selling and administrative variable costs will increase by 5%
Selling and administrative fixed costs will decrease by 10%
Production will increase by 15% which is the same as the sales volume increase.
There will still be no change in inventory.
Fixed costs will decrease by 5%.
Â
Â
-On the fifth tab, prepare the alternative master budget along with the supporting schedules for the six schedules according to the assumptions. Be sure to insert formulas in the EXCEL cells. The model needs to be created so if I change the assumptions, its still correct. It's similar to the other budgets I tweaked on the other tabs.
Attachments:
Answers
Status NEW
Posted 20 Jun 2017 02:06 AM
My Price 10.00
-----------
Attachments
file 1497924896-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)