I need C and D only Please show your work 1. Wanda Mboweni has started a small b
ID: 3869612 • Letter: I
Question
I need C and D only Please show your work
1. Wanda Mboweni has started a small business to sell ride-on lawn mowers, lawn tractors, and a new line of product in the market – robotic lawn mowers. She has selected two products to sell as shown in the table, and wants you to add two more products that fit the mower categories in her product line and also add variety to the product offerings.
Products Retail Price Wholesale Cost
Husqvarna 23 hp 48 in. Deck Yard Tractor $1,800 $1,450
Toro TITAN ZX5000 Riding Lawn Mower $4,000 $3,200
Wanda wants to earn the most profit she can, but she has to operate within some business constraints. She wants your help in estimating the maximum profit she can earn while meeting the following constraints.
• Wanda has obtained a business loan of $600,000 to purchase the inventory that she wants to sell. Therefore, the total wholesale cost of her inventory cannot exceed $600,000.
• Wanda must purchase a minimum of 10 units of each item from the manufacturers.
• Wanda does not want to stock more than 120 units of any model except the robotic type to minimize the risk of stocking too many of a slow moving mower model. Since the robotic models are not yet quite popular, Wanda wants to hold a lower stock level of such models not to exceed 30 for each such model.
Do the following to help Wanda
a) (3 point). Use the Internet to locate the retail price of two more lawn mower models that fit the mower categories in her product line and also add variety to the product offerings. You must have at least one robotic model. Consider the wholesale price of each unit to be 75% of the retail price for both units you find.
b) (5 points). Create a worksheet in Microsoft Excel to enter the data and set up your calculations as shown below. Apply some format to the worksheet to make it look good. Enter the data. Note that all the constraint related data should be added as shown.
Below is the excel sheet. Total profit obtained is: $166824.6775.
Item #
Products
Retail Price
Wholesale Cost
Profit per Unit
Purchase Quantity
Total Cost
Total Profit
1
Husqvarna 23 hp 48 in. Deck Yard Tractor
1800
1450
350
11
15950
3850
2
Toro TITAN ZX5000 Riding Lawn Mower
4000
3200
800
120
384000
96000
3
Cub Cadet LT46 (46") 22HP Kohler Lawn Tractor
1,799.99
1349.9925
450.00
10
13499.925
4499.975
4
Cub Cadet LT50 (50") 24HP Kohler Lawn Tractor
2,099.99
1574.9925
525.00
119
187424.1075
62474.7025
Totals
260
600874.0325
166824.6775
Constraints
Buisness loan
600000
Minimum units of each model
10
Maximum units of each model except robotic type
120
Robotic model maximum unit
30
C. (8 points). Enter the required formulas. Enter a purchase quantity of 10 for each item, which will fill out the table with corresponding results.
D. (3 point). Store a scenario naming it as Minimum purchase. What are the Total Purchase Quantity, Overall Total Cost, and the Overall Total Profit
Item #
Products
Retail Price
Wholesale Cost
Profit per Unit
Purchase Quantity
Total Cost
Total Profit
1
Husqvarna 23 hp 48 in. Deck Yard Tractor
1800
1450
350
11
15950
3850
2
Toro TITAN ZX5000 Riding Lawn Mower
4000
3200
800
120
384000
96000
3
Cub Cadet LT46 (46") 22HP Kohler Lawn Tractor
1,799.99
1349.9925
450.00
10
13499.925
4499.975
4
Cub Cadet LT50 (50") 24HP Kohler Lawn Tractor
2,099.99
1574.9925
525.00
119
187424.1075
62474.7025
Totals
260
600874.0325
166824.6775
Constraints
Buisness loan
600000
Minimum units of each model
10
Maximum units of each model except robotic type
120
Robotic model maximum unit
30
Explanation / Answer
Purchase quantity for 10
1.Husqvarna 23 hp 48 in. Deck Yard Tractor
For 11
Total cost =15950
Total profit= 3850
Profit per unit= 350
For 10
15950/11=1450
1450*10= 14500
Total cost=14500
Toatal profit= 3500
2.Toro TITAN ZX5000 Riding Lawn Mower
For 10
384000/120=3200
3200*10= 32000
For 10 total cost = 32000
Total profit = 800*10= 8000
4.Cub Cadet LT50 (50") 24HP Kohler Lawn Tractor
187424.1075/119= 1574.9925
1574.9925*10= 15749.992
Total cost = 15749.992
Total profit=525*10= 5250
D
Total purchase quantity for 10 =40
Overall Total cost = 14500+32000+15749.992+13499.925
= 75749.917
Overall total profit= 3500+8000+5250+4499.975
= 21249.975
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.