archmage only

IS130 DSS in Excel James Henson

Manufacturer Model Projected Sales

GBI DXT 28

GBI PTX 55

GBM Tiger 48

Whitman Tailwind 30

Peterson PBY 60

Talbot Lago 2 18

Manufacturer Model Cost Each Total cost

GBI DXT 1,124.00$ 31,472.00$

GBI PTX 1,085.35$ 59,694.25$

GBM Tiger 987.60$ 47,404.80$

Whitman Tailwind 1,350.00$ 40,500.00$

Peterson PBY 886.50$ 53,190.00$

Talbot Lago 2 1,495.00$ 26,910.00$

259,171.05$

Markup:

25%

Manufacturer Model Selling Price Sales Income

GBI DTX 1,405.00$ 39,340.00$

GBI PTX 1,356.69$ 74,617.81$

GBM Tiger 1,234.50$ 59,256.00$

Whitman Tailwind 1,687.50$ 50,625.00$

Peterson PBY 1,108.13$ 66,487.50$

Talbot Lago 2 1,868.75$ 33,637.50$

Total Sales: 323,963.81$

Total Cost of Projected Sales:

Rent 21,000.00$

Utilities 2,900.00$

Payroll 62,500.00$

Total Fixed Costs 86,400.00$

Total Sales 323,963.81$

Cost of Goods Sold 259,171.05$

Gross Profit 64,792.76$

Total Fixed Costs 86,400.00$

Net Profit (Loss) (21,607.24)$

Fixed Costs per Year

Balance Sheet Calculations

$-

$10,000.00

$20,000.00

$30,000.00

$40,000.00

$50,000.00

$60,000.00

$70,000.00

$80,000.00

Sales Income

DTX

PTX

Tiger

Tailwind

PBY

Lago 2