8 questions in total, answer them in excel
Description
Unformatted Attachment Preview
Trojan Juice
(8 points)
Revenues, variable costs
Revenue
Variable cost
Juice
$2.25
$1.35
Bags
$2.00
$1.20
Grades used to make juice and bags
Grade
Juice
Bags
6
10000.0 25000.0
9
90000.0 50000.0
Total Sold
100000
75000
Required average quality
Juice
8
Bags
7
Juice
9
>=
8
Bags
8
>=
7
Quality constraints
Actual
Required
Total variable cost
Total revenue
$225,000
$375,000
Profit
$150,000
Used
35000
140000
Purchase answer to see full
attachment
(8 points)
Revenues, variable costs
Revenue
Variable cost
Juice
$2.25
$1.35
Bags
$2.00
$1.20
Grades used to make juice and bags
Grade
Juice
Bags
6
10000.0 25000.0
9
90000.0 50000.0
Total Sold
100000
75000
Required average quality
Juice
8
Bags
7
Juice
9
>=
8
Bags
8
>=
7
Quality constraints
Actual
Required
Total variable cost
Total revenue
$225,000
$375,000
Profit
$150,000
Used
35000
140000
Purchase answer to see full
attachment
Explanation & Answer:
Worksheet
User generated content is uploaded by users for the purposes of learning and should be used following our honor code & terms of service.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
Complete the 
Complete the order payment after filling in the order form. We’ll receive your order and assign it to a writer.
The assigned writer will complete your paper and forward it to our Editing Team for review and approval.
Once approved by the editor, the completed paper will be uploaded to your account for you to download, review and approve.