Question: Complete your Category Summary by writing an Excel formula in cell F14, which can be copied down the column, to determine the total costs of
Complete your Category Summary by writing an Excel formula in cell F14, which can be copied down the column, to determine the total costs of all campaign items in the corresponding category (excluding shipping) for the Design Company (Column G).
| Campaing Fundraising Analysis | ||||||
| Shipping Costs | 3% | |||||
| Type | Category | Number | In House | Design Company | In House Cost | Design Company Cost |
| Postcards | Fundraising | 5000 | $ 2.40 | $ 2.25 | $12,000.00 | $ 11,250.00 |
| Brochures | Information | 1500 | $ 3.99 | $ 4.10 | $ 5,985.00 | $ 6,150.00 |
| Yard Signs | Fundraising | 700 | $ 1.65 | $ 1.05 | $ 1,155.00 | $ 735.00 |
| Stickers | Fundraising | 3500 | $ 0.35 | $ 0.30 | $ 1,225.00 | $ 1,050.00 |
| Total cost w/shipping | $20,975.95 | $ 19,760.55 | ||||
| # items ordered | 4 | Category Summary | ||||
| average cost of the 2 orders | $20,368.25 | # items | Total Cost | |||
| min cost order incl. shipping | $19,760.55 | Information | 1 | |||
| # Company A items over $2 | 2 | Fundraising | 3 | |||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock