Can I get help with in 1 hour or less Please
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 | $4,500 | $2,400 | $1,100 |
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 | ||
Small business | ||
Individual |
Monthly Call/Visit Plan | |||
---|---|---|---|
Total number of customers |
Total number of visit hours |
Total commissions |
|
Large business | |||
Small business | |||
Individual | |||
Grand totals: |
a)
Large Business | Small Business | Individual | |
No. of Customers (a) | 8 | 35 | 80 |
Avg. Monthly Sales Per Customer (b) | $4500 | $2400 | $1100 |
Commission % (c) | 5% | 8% | 10% |
Hours Per Customer Per Monthly visit (d) | 5 | 3 | 2.5 |
Commission per Customer (e) = (b*c) | $225 | $192 | $110 |
Total Commission (a*b*c) | $1800 | $6720 | $8800 |
Commission per Hour (e/d) | $45 | $64 | $44 |
Rank | 2 | 1 | 3 |
b)
Large Business | Small Business | Individual | |
Total No. of Customers (a) | 8 | 35 | 80 |
Hours Per Customer Per Monthly visit (b) | 5 | 3 | 2.5 |
Total Hours (c) | 40 | 105 | 200 |
Total Hours (as per rank with maximum 160) (d) | 40 | 105 | 15 |
Total No. of Customers needed (e)=(d/b) | 8 | 35 | 6 |
Avg. Monthly Sales Per Customer (f) | $4500 | $2400 | $1100 |
Commission % (g) | 5% | 8% | 10% |
Total Commission (e*f*g) | $1800 | $6720 | $660 |
Can I get help with in 1 hour or less Please Limited Resources Maria Pajet, a...
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...
please help me answer this asap. thank you! Maria operates a nail salon. She is trying to plan her costs for the next month and is uncertain as to how to estimate those costs. Help her estimate next month's costs given the following information she collected, based on number of customers per month. Nail supplies Equipment Rental Electricity Total 1300 $3640 2500 300 $6440 Number of Customers 1850 1600 $5180 $4480 2500 2500 410 360 $8090 $7340 1100 $3080 2500...
Maria Chavez owns a catering company that serves food and beverages at parties and business functions. Chavez’s business is seasonal, with a heavy schedule during the summer months and holidays and a lighter schedule at other times. One of the major events Chavez’s customers request is a cocktail party. She offers a standard cocktail party and has estimated the cost per guest as follows: Food and beverages $ 17.00 Labor (0.5 hour @ $11.00 /hr.) 5.50 Overhead (0.5 hour @...
Required information The following information applies to the questions displayed below.) Maria Chavez owns a catering company that serves food and beverages at parties and business functions. Chavez's business is seasonal with a heavy schedule during the summer months and holidays and a lighter schedule at other times. One of the major events Chavez's customers request is a cocktail party. She offers a standard cocktail party and has estimated the cost per guest as follows: Food and beverages Labor (0.5...
i been trying a lot but i dont know how to calculate Maria Chavez owns a catering company that serves food and beverages at parties and business functions. Chavez's business is seasonal, with a heavy schedule during the summer months and holidays and a lighter schedule at other times. One of the major events Chavez's customers request is a cocktail party. She offers a standard cocktail party and has estimated the cost per guest as follows: Food and beverages Labor...
can i get the answer to this question? due in about an hour Acme Widget Company, based in Oregon, makes widgets for the US market. Each widget sells for $200 at retail (price that customers pay). Acme Widget, however, does not sell widgets directly to consumers. It has dealers who get a 35% dealer commission (off retail customer price of $200) for each widget they sell to end-user for $200. Each widget uses $5.15 of titanium; $26.75 worth of chips...
Required information The following information applies to the questions displayed below.) Maria Chavez owns a catering company that serves food and beverages at parties and business functions. Chavez's business is seasonal, with a heavy schedule during the summer months and holidays and a lighter schedule at other times. One of the major events Chavez's customers request is a cocktail party. She offers a standard cocktail party and has estimated the cost per guest as follows: Food and beverages Labor (0.5...
Additional Information for the questions below: Maria is not comfortable with the estimate of overhead cost. Information is provided in the case for labor hours and overhead expenses. The least-squares regression method can be used to estimate the fixed and variable components of overhead expenses. You do not have to compute this. The cost formula, in the form Y = a + bx, using labor-hours as the activity base is $48,126 per month plus $3.95 per labor-hour, or: Y =...
Experts, Can I get answer in 1 hour or less . please Thank you Special Order: High-Low Cost Estimation SafeRide, Inc. produces air bag systems that it sells to North American automobile manufacturers. Although the company has a capacity of 300,000 units per year, it is currently producing at an annual rate of 180,000 units. SafeRide, Inc. has received an order from a German manufacturer to purchase 60,000 units at $7.00 each. Budgeted costs for 180,000 and 240,000 units are...
Please can someone help me with making this program in JAVA implementing classes. Also, include loops and selection structures. A mobile service provider has three different subscription packages for its customers: Package A: For $50 per month, 5 GB data are provided. Additional data is $15 per GB. Package B: For $65 per month, 10 data are provided. Additional data is $10 per GB. Package C: For $75 per month unlimited data provided. Text messaging and voice services are included...