Practice

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

Budget

Income:
Salary: $ 50,000
Taxes (22%): $ 11,000 =22%*B4
Medical: $ 5,000
Dental: $ 500
Retirement: $ 5,000
Net Income: $ 28,500 =B4-B5-B6-B7-B8
$ 28,500
Expenses:
Rent: $ 18,000
food: $ 5,000
Car $ 5,000
Travel $ 2,000
apt items $ 1,000
pet $ 1,000
gifts $ 500
savings $ 5,000
loans $ 10,000
Total expenses: $ 47,500
net savings ₹ -19,000

NCAA T-Shirt Vendor


Given:
Costs
Fixed cost $ 750
Variable cost $ 8 per shirt
Revenue
Selling Price (Full price) $ 18 per shirt
Leftover sells at(reduced price) $ 6 per shirt

No.of shirts ordered $ 1,450


Demand $ 1,500
No.of shirts ordered (Full price) $ 1,450
No.of shirts ordered (reduced price) $ -

Total cost $ 12,350


Total revnue 26100
total profit $ 13,750 =B40-B39

Woodworks co.
Costs: Cherry Oak
Unit Cost $ 5.5 $ 4.3
Board feet 30 30
Material cost: $ 165 $ 129
Labor req 16 16
Labor rate $ 18.5 $ 18.5
Labor cost $ 296.0 $ 296.0

Total cost $ 461.0 $ 425.0

cost Inc: 2.40% 1.70% 1.50%

Year cherry oak labor total cherry total oak


0 $ 165 $ 129 $ 296.00 $ 461.00 $ 425.00
1 $ 168.96 $ 131.19 $ 300.44 $ 469.40 $ 431.63
2 $ 173.02 $ 133.42 $ 304.95 $ 477.96 $ 438.37
3 $ 177.17 $ 135.69 $ 309.52 $ 486.69 $ 445.21
4 $ 181.42 $ 138.00 $ 314.16 $ 495.58 $ 452.16
5 $ 185.77 $ 140.34 $ 318.88 $ 504.65 $ 459.22

Woodworks co.
$520.00

$500.00

$480.00
TOTAL COST

$460.00

$440.00

$420.00

$400.00

$380.00
0 1 2 3 4 5

YEARS

total cherry total oak

You might also like