2020 S02 P03 EXCEL

The management of Fight Back Pharmaceuticals (Pty) Ltd (FBP) was very impressed with your Microsoft Excel ability. They further requested your assistance in supporting the company to increase the supply of products to meet the societal needs within the various regions. Due to the increase in demand, FBP was asked to supply the products on a weekly basis, as stocks were being sold out at their clients at the end of every week. As a result, FBP have decided to issue a travel allowance to each driver based on the distance travelled.

In order to meet the needs of their clients, FBP’s management team has also taken the decision to invest in a multi-purpose production machine, which will assist them in the production of their products on a much larger scale. Your role is to assist FBP’s management in order to:

  • Determine the monthly instalment on the acquisition of the new multi-purpose production machine
  • Provide some analysis concerning the orders to be dispatched to the warehouses.

VAT implications are negligible however, FBP is a VAT vendor.

You were issued with the following analysis spreadsheet report for October:

FBP’s management team also provided you with the following additional information that can be mostly obtained in the provided spreadsheet :
a) The cost price of the new multi-purpose machine, refer to cell B4.
b) The term of the finance instalment, refer to cell B5.
c) The annual interest rate of the loan, refer to cell B6.
d) All payments are made at the end of each month.
e) The distance/rate table is used to indicate the range of kilometres (km) and the rate per kilometre (km) travelled by a driver which will constitute an allowance per trip. Refer to the cell range D3:F7.
f) The structure for the new pharma code consists of eleven (11) characters. The New pharma code is a combination of the province code, energy supplement, a hyphen/dash and the energy code (refer to range G14:G19).
Note: The new pharma code structure in question 5 and question 6 refer to the same code
The New pharma code structure must be as follow:

1 2 3 4 5 6 7 8 9 10 11
N C 5 2 6 2 0 0 H S

Characters 1 to 2 :           The province code
Characters 3 to 5 :           The distance to travel to the location (kms)
Character 6 :                     ( – ) Hyphen/Dash
Characters 7 to 9 :           The demographic region
Characters 10 to 11:       The product description initials

Please login to get access to this quiz