The FBLA is going to purchase a screen printing machine to start a business of creating shirts for the various teams and clubs of the school. They will need to find an organization to put up the initial cost of $8000 for the machine. They proposal will be to pay back this organization the full amount by making payments of 50% of the profit on each batch/sale. Analyze the data to figure out about how long it will take to pay back the loan.

Create the following Table:

Table for Tracking Profits

A

B

C

D

E

F

G

H

1

FBLA SCREEN PRINTING

2

Meeker High School

3

Year 1

Year 2

Year 3

Year 4

Year 5

...

Total

4

Volleyball

5

Football

6

Golf

7

Cross Country

8

Boy's Basketball

9

Girl's Basketball

10

Wrestling

11

Track

12

Baseball

13

Rec. Center

14

Total Shirts Sold

15

Total Profit

16

Amount Paid Back to Donator

17

Running total Paid Back

18

Total left on Loan

19

20

ASSUMPTIONS

21

Original Cost of Equipment

$8,000.00

22

% Profit back to Donator

50%

23

Markup per Shirt

$5.00

24

Sales Growth

2%

Italic text

Fill in the estimated number of shirts each group would sold for year 1.

Compute the number of shirts sold for year 2 = prior year *(1+sales growth)

Compute the rest of the years sales with the same basic formula

You might have to have more than 5 years to pay this off

Make sure you look at your absolute and relative references on your formulas

Find the total shirts sold for each year

Compute the Total Profit = total shirts sold * Markup per shirt

Make sure you look at your absolute and relative references on your formulas

Compute Amount Paid back to Donator = 50% of Profit

Make sure you look at your absolute and relative references on your formulas

Compute Running Total Paid Back = Running Total Paid Back previous year plus Amount Paid Back this year

You will need to think on your own

Logically how much do you have paid back the first year?

Logically how can you find out how much is paid back the first two year?

What can your formula be so you can use the fill handle?

Make sure you look at your absolute and relative references on your formulas

Compute Total left on Loan = Original cost of the Equipment - Running Total Paid Back

Make sure you look at your absolute and relative references on your formulas

Create a Conditional Formatting on the Left on Loan to change the color of font and fill color when the value goes negative.

Print the spreadsheet on one page

Print the Formula View to one page

Adjust the Assumptions to figure out how the loan could be paid off in one less year.

User makes a logical guess for our high school on the numbers of shirts we could sell.

Uses Sales Growth Correctly to compute future years sales.

User needed major help to get the formula to work

User needed assistance three times

User needed assistance twice

User needed assistance on one step

User can create the formula to compute sales growth and figure future sales for each year accurately using absolute and relative references.

Computes total profit using assumptions

User needed major help to get the formula to work

User needed assistance three times

User needed assistance twice

User needed assistance on one step

User can create the formula to compute total profit for each year accurately using absolute and relative references.

Compute amount paid back to donator

User needed major help to get the formula to work

User needed assistance three times

User needed assistance twice

User needed assistance on one step

User can create the formula to compute amount paid back to donator for each year accurately using absolute and relative references.

Compute the running total paid back

User needed major help to get the formula to work

User needed assistance three times

User needed assistance twice

User needed assistance on one step

User can create the formula to compute running total paid back for each year accurately using absolute and relative references.

Computes the total left on loan

User needed major help to get the formula to work

User needed assistance three times

User needed assistance twice

User needed assistance on one step

User can create the formula to compute the total left on the loan for each year accurately using absolute and relative references.

Creates Conditional Formatting

User needed major help to get the formula to work

User needed assistance three times

User needed assistance twice

User needed assistance on one step

User can create conditional formatting on total left on loan to show negative values as a different color font and fill color.

Uses What-If Analysis

User needed major help to get the assumptions to work

User needed assistance three times

User needed assistance twice

User needed assistance on one step

User can use the assumptions to adjust the data in the spreadsheet to answer questions for projection data.

Prints the spreadsheet

Only printed one page and it is not fit to one page

Missing two and/or and not fit to a page

Missing a page and more than one is not fit to a page

Missing a page, or not fit to one page

Print the original spreadsheet filled in, prints in regular and formula view. Then prints again with the what-if assumptions filled in. A total of three pages should be printed forcing each to fit to one page.