Question

In: Accounting

Limited Resources Maria Pajet, a regional sales representative for UniTec Systems, Inc., has been working about...

Limited Resources
Maria Pajet, a regional sales representative for UniTec Systems, Inc., has been working about 80 hours per week calling on a total of 123 regular customers each month. Because of family and health considerations, she has decided to reduce her hours to a maximum of 160 per month. Unfortunately, this cutback will require Maria to turn away some of her regular customers or, at least, serve them less frequently than once a month. Maria has developed the following information to assist her in determining how to best allocate time:

Customer Classification
Large
Business
Small
Business
Individual
Number of customers 8 35 80
Average monthly sales per customer $3,500 $1,800 $800
Commission percentage 5% 8% 10%
Hours per customer per monthly visit 5.0 3.0 2.5


a. Develop a monthly plan that indicates the number of customers Maria should call on in each classification to maximize her monthly sales commissions.
b. Determine the monthly commissions Maria will earn if she implements this plan.

In the first table, calculate the commission per customer and per hour for each customer classification.

In the second table, complete the monthly call/visit plan that would maximize Maria's monthly sales commissions. Then determine Maria's monthly commissions if she implements this plan.

Commission
per customer
Commission
per hour
Large business $Answer $Answer
Small business $Answer $Answer
Individual $Answer $Answer
Monthly Call/Visit Plan

Total number

of customers

Total number

of visit hours

Total

commissions

Large business Answer Answer Answer
Small business Answer Answer Answer
Individual Answer Answer Answer
Grand totals: $Answer Answer $Answer

Solutions

Expert Solution

1. Since Maria wants to reduce her working hours, so in order to maximise commission earnings she should serve those customers first from which she earns maximum commission per hour and least priority should be given to those from whom she earns less commission per hour. Let us first compute commission per hour from different customers.

Customer Classification
Large Small Individual
Business Business
Number of customers 8 35 80
Average monthly sales per customer(USD) 3,500.00 1,800.00      800.00
Commission percentage 5% 8% 10%
Hours per customer per monthly visit 5 3 2.5
Total Commision (Average monthly sales*Commission percentage) (USD) (A)         1,400         5,040           6,400
Total Hours per month (Number of customers*Hours per customer) (B) 40 105 200

Commission per hour (A)/(B)

        35.00         48.00           32.00
Commission per customer (Total Commission / No. of Customers)      175.00      144.00           80.00

Since Maria is earning highest commission per hour from Small Business, so she should give first priority to Small Business, second priority to Large Business and finally to Individuals.

Since she wants to work a maximum of 160 hours for the month, so let us compute the numbers of hours for different types of customers.

Small Business: 105 hours

Large Business: 40 hours

Individuals: 160-105-40 = 15 hours

Number of customers she should serve should be as follows:

Small Business: All 35 customers as she can devote fulll time based on priority to them

Large Business: All 8 customers as she still have sufficient time

Individuals: Since only 15 hours are left for individuals, number of customers will be only 6 (15 i.e. total hours left divided by 2.5 i.e. hours per customer).

Based on above computed plan, Maria's commission will be computed as follows:

Monthly Call/Visit Plan
Total number Total number Commission Total
of customers of visit hours per hour commissions
Large business 8 40 35 1400
Small business 35 105 48 5040
Individual 6 15 32 480
Grand totals: 49 160 115 6920

Apologies for not answering in the exact format required, as somehow I an not able to copy table in the answer.


Related Solutions

Maria Pajet, a regional sales representative for UniTec Systems Inc. has been working about 80 hours...
Maria Pajet, a regional sales representative for UniTec Systems Inc. has been working about 80 hours per week calling on a total of 123 regular customers each month. Because of family and health consider- ations, she has decided to reduce her hours to a maximum of 160 per month. Unfortunately, this cutback will require Maria to turn away some of her regular customers or, at least, serve them less frequently than once a month. Maria has developed the following information...
Maria Pajet, a regional sales representative for UniTec Systems, Inc., has been working about 80 hours...
Maria Pajet, a regional sales representative for UniTec Systems, Inc., has been working about 80 hours per week calling on a total of 123 regular customers each month. Because of family and health considerations, she has decided to reduce her hours to a maximum of 160 per month. Unfortunately, this cutback will require Maria to turn away some of her regular customers or, at least, serve them less frequently than once a month. Maria has developed the following information to...
Azaan has been working for an HDBL life insurance company as a sales representative for more...
Azaan has been working for an HDBL life insurance company as a sales representative for more than five years in Sur, Sultanate of Oman. He achieves his targets on time because of his product knowledge, good communication and presentation skills. He regularly attends several workshops on sales and marketing to enhance his marketing and sales skills. HDBL Life Insurance Company is happy with Azaan's performance and gives him a good salary and commission on additional sales. Azaan has several general...
Azaan has been working for an HDBL life insurance company as a sales representative for more...
Azaan has been working for an HDBL life insurance company as a sales representative for more than five years in Sur, Sultanate of Oman. He achieves his targets on time because of his product knowledge, good communication and presentation skills. He regularly attends several workshops on sales and marketing to enhance his marketing and sales skills. HDBL Life Insurance Company is happy with Azaan's performance and gives him a good salary and commission on additional sales. Azaan has several general...
Azaan has been working for an HDBL life insurance company as a sales representative for more...
Azaan has been working for an HDBL life insurance company as a sales representative for more than five years in Sur, Sultanate of Oman. He achieves his targets on time because of his product knowledge, good communication and presentation skills. He regularly attends several workshops on sales and marketing to enhance his marketing and sales skills. HDBL Life Insurance Company is happy with Azaan's performance and gives him a good salary and commission on additional sales. Azaan has several general...
Consider Transaction Processing Systems, Management Information Systems, and Decision Support Systems. A regional sales manager is...
Consider Transaction Processing Systems, Management Information Systems, and Decision Support Systems. A regional sales manager is suffering from unexpectedly low sales of a new product. How can s/he use each of the above systems for diagnosing the cause of this problem?
Johan Yee has been a sales representative at a medium-sized textbook publishing house for five years....
Johan Yee has been a sales representative at a medium-sized textbook publishing house for five years. He has just been promoted by the sales director of his company to sales manager of a new territory. As sales manager, he is tasked with hiring and training three new sales representatives for his team. a. Write a suitable job description and personnel specification for sales representatives. b. Johan crafts a descriptive ad and receives hundreds of resumes in response. He reads through...
LaCrosse, Inc., sales manager Josh Brown has been receiving calls from customers complaining about the length...
LaCrosse, Inc., sales manager Josh Brown has been receiving calls from customers complaining about the length of time it takes to receive an order. To help him understand the issue, he gathered the following information from DanGold Enterprises’ most recent order. Days Required Process customer order : 0.1 Wait for direct materials to arrive : 4.0 (a) Calculate the delivery cycle time for DanGold’s order. (Round answer to 1 decimal place, e.g. 12.5.) Delivery cycle time Enter the delivery cycle...
LaCrosse, Inc., sales manager Josh Brown has been receiving calls from customers complaining about the length...
LaCrosse, Inc., sales manager Josh Brown has been receiving calls from customers complaining about the length of time it takes to receive an order. To help him understand the issue, he gathered the following information from DanGold Enterprises’ most recent order. Days Required Process customer order 0.2 Wait for direct materials to arrive 4.0 Fabrication of parts 3.0 Move order to assembly department 0.6 Wait for machine time 6.5 Assembly of parts 4.0 Move order to finishing department 0.3 Wait...
Big Spenders Inc Big Spenders Inc. has been working on diversifying its portfolio of investments and...
Big Spenders Inc Big Spenders Inc. has been working on diversifying its portfolio of investments and requires accounting advice for a decision between two car cleaning and detailing companies. Annual cash inflows from two competing investment opportunities are given below. Each investment opportunity will require the same initial investment Cleaning $3,000 and Detailing $3,200. Compute the present value of the cash inflows for each investment using an 8% discount rate for Cleaning and 10% for Detailing. Year Cleaning Detailing Discount...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT