A. The payments due to each sales manager need to be calculated. The sales managers each earn a
monthly salary of £2000. They also earn a bonus of £200 if their sales are more than the average
for the month and receive a mileage expenses payment of 40p for every mile driven.
The office manager has provided you with data on the sales and mileage of each sales manager
for this month. (Image below Task B)
B. Present the total sales for the four areas (North/Midlands/South East/South West), so that
they can be compared.
C. Fuel costs have risen, so the business has increased the mileage expenses payment to
sales managers to 47p for every mile. Use your solution to model the effect this will have on
the total amount to be paid to all sales managers this month.
D. The maximum amount the bonuses could be razed by is £80 (per person) to a total of £280 and costing the company a total of £46969.96
Link to the MAC Version of the spreadsheet
Link to the WINDOWS Version of the spreadsheet


LE-MERIDIAN FINANCING SERVICES. the loan company that grant me loan of 5,000,000.00 USD When other loan investors has neglect my offer but Le_Meridian Funding Service grant me success loan.they are into directly in loan financing and project in terms of investment. they provide financing solutions to companies and individuals seeking access to capital markets funds, they can helped you fund your project or expand your business.. Email Contact:::: lfdsloans@lemeridianfds.com Also lfdsloans@outlook.com or Write on whatsapp Number on 1-(989-394-3740)Good Intend,
ReplyDelete