If I have 1360 kg of peanuts, 1260 kg of cashews, and 2000 kg of macadamias. How many packs could be made, if one pack contains 40% of peanuts, 40% of cashews, and 20% of macadamias.
The following three one-year “discount” loans are available to
you:
Loan A: $120,000 at a 7 percent discount rate
Loan B: $110,000 at a 6 percent discount rate
Loan C: $130,000 at a 6.5 percent discount rate
a. Determine the dollar amount of interest you would pay on
each loan and indicate the amount of net proceeds each loan
would provide. Which loan would provide you with the most
upfront money when the loan takes place?
b. Calculate the percent interest rate or effective cost of each
loan. Which one has the lowest cost?
Ryan Miller wanted to make some money at a flea market. He purchased 55 small orchids from a nursery for a total of $233.75, three bags of potting soil for $2.75 each, and 55 ceramic pots at $4.60 each. After planting the orchids in the pots, Ryan sold each plant for $15.50 at the flea market.
Amount Sold
Variables Used Small RFP Selling Price= $7.00 2
Medium RFP Selling Price= $10.00 4
Large RFP Selling Price= $15.00 2
BT Selling Price $3.50 20
Small RFP Cost= $5.00
Medium RFP Cost= $8.00
Large RFP Cost= $12.00
BT Cost
Excel Formulas Total Profit
Total Cost
Markup % based on cost=
In the yellow cells, create the Microsoft® Excel® formulas that will give you the total profit, total cost, and required markup percentage based on cost. Use cell references in the formula—do NOT use numbers.
"assignmentexpert.com" is professional group of people in Math subjects! They did assignments in very high level of mathematical modelling in the best quality. Thanks a lot