Projected Annual Costs of Running Suit Revival

Task 1
This spreadsheet calculates the projected annual outgoing costs of running
Suit Revival.
Input
The spreadsheet is configured such that the working hours, hourly rates, and
fixed and utility costs can be varied by the user in the highlighted cells.
Assumptions
The following assumptions have been made
 There are 52 weeks in a year.
 Casual replacements are expected to work for 4 weeks.
 Monthly utility cost will be multiplied by 12
Output
The table below summarizes the annual projected costs of running suit
revival
Description Annual
Costs
Fixed costs $
9,100.00
Utility costs $
3,120.00
Annual Salaries $
96,876.00
Total Projected costs $
109,096.0
0

Task 2
Approach
To associate each quote with a staff member, the analysis below was performed on the raw data.
Determine actual Weekday
- Using excel formula, TEXT (quote date under column A,"dddd") ,column F allocates the actual
weekday for each quote entry entered by Conrad during the week.
Determine Actual Staff member
- We have been given that Alfred and Bhavesh work together to manufacture suits. Furthermore,
Alfred works Monday, Tuesdays and Wednesday, while Bhavesh works on Thursday and Friday.
- Using Excel’s IF function and the actual weekdays under column F, Column G allocates the
actual staff member associated to each quote entry.
Findings
How some aspect of quoting or manufacturing has changed over time
The chart below analyses how quote and manufacturing prices are changing over time. These
values are based on the average quoted amounts and manufacturing costs.