Plan A assumptions Plan A - Assumptions - M. Hayes
Sales - PRICES PER Box
Spinners
Cubes Jul Decrease in prices
Sales - UNITS
Spinners
Cubes Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun Total Jul-18 Oct Nov Dec Jan Feb Mar Apr May Jun Total Jul-18 from Nov 2017 onwards
Jul Aug Sept Beginnning Inventory of Boxs, July 1, 2017
Spinners
Cubes
Ending monthly inventory of the following month's COGS Cost per Box
Spinners
Cubes
Factory - building
Loan
APR
Term of loan years Residual value
Useful life years Operating Expenses:
Commissions
Commissions
Commissions
Shipping
Rent
Rent
Advertising Expense
Advertising Expense
Salaries Expense
Utilities Expense
Insurance Expense
Depreciation Expense
Mortgage Interest Expense $ 350,000
if monthly sales <
$ 350,000
if monthly sales > =
$ 550,000
if monthly sales > =
of sales per month
per month - July 2017 - December 2017
per month - beginning in January 2018
per month - excluding January & February, 2018
per month - January & February, 2018 ONLY
per month
per month
per month
per month
*see mortgage loan repayment schedule Income Taxes:
Net income Tax Rate Plan A Plan A - Budgets Jul Aug Sept Oct Nov Fidget Widgets
Sales Budget
For the period ending June 30, 2018
Dec
Jan
Feb Mar Nov Fidget Widgets
Merchandise Purchases Budget
For the period ending June 30, 2018
Dec
Jan
Feb Mar Sales - Spinners
Sales - Cubes
Total Sales Jul
Spinners
Cost of Goods Sold
Add: ending inventory
Total Needs
Less: beginning inventory
Purchases of Spinners
Cubes
Cost of Goods Sold
Add: ending inventory
Total Needs
Less: beginning inventory
Purchases of Cubes
Total Purchases Aug Sept Oct Nov Fidget Widgets
Operating Expenses Budget
For the period ending June 30, 2018
Dec
Jan
Feb Mar Nov Fidget Widgets
Budgeted Income Statement
For the period ending June 30, 2018
Dec
Jan
Feb Mar Plan A Jul Aug Sept Oct VARIABLE EXPENSES
Selling Commissions
Shipping
Total Variable Expenses
FIXED EXPENSES
Rent
Advertising
Salaries
Utilities
Insurance
Depreciation
Total Fixed Expenses
Total Operating Expenses Jul
Sales
Cost of Goods Sold
Gross Profit
Operating Expenses
Income before interest and taxes
Interest expense
Income before taxes
Income tax (refund)
Net Income (loss) Aug Sept Oct Plan A Plan A Plan A Plan A Add: Desired ending inventory
Less: Beginning inventory Plan A
Fidget Widgets
Sales Budget
For the period ending June 30, 2018
Apr May Jun Total Jul-18 Apr May Jun Total Jul-18 Fidget Widgets
Merchandise Purchases Budget
For the period ending June 30, 2018 Fidget Widgets
Operating Expenses Budget
For the period ending June 30, 2018 Plan A Apr May Jun Total Jul-18 Apr May Jun Total Jul-18 Fidget Widgets
Budgeted Income Statement
For the period ending June 30, 2018 Plan A Plan A Plan A Plan A Loan Calculator
Enter Values
Loan Amount
Annual Interest Rate
Loan Period in Years
Number of Payments Per Year
Start Date of Loan
Scheduled Payment
Pmt No. Payment Date Beginning Balance 7/1/2017 Scheduled
Payment Principal Interest Ending Balance

 

• 1497933889-ask1.xlsx
• 1497933891-ask.docx

SuperTutor

(15)

Status NEW Posted 20 Jun 2017 04:06 AM My Price 20.00

-----------

Attachments

file 1497933898-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