Answered step by step
Verified Expert Solution
Question
1 Approved Answer
question 1 please i need help with this question with the exact excel sheet. thank you 1- A staple company must replace one of its
question 1 please i need help with this question
1- A staple company must replace one of its machines and is evaluating the two proposals offered by the providers. Technofil is asking for $70000 in fixed costs. Each staple box produced using Technofil Machine would have a variable cost of $15. Rudolf Grauer AG is asking $57000, and staple boxes made on this machine would have a variable cost of $17. Technofil Machine would have the capacity to make 20000 staple boxes per year, which is double the capacity for Rudolf Grauer Machine. (15 pts) a. If staple boxes sell for $25 cach, find the break-even point for each machine. Perform the calculations just for one year. b. If the company estimates a demand of 8900 units in the next year, which machine should be selected? c. At what level of production (same number of boxes for both machines) do the two production machines cost the same? A B B D E Rudolf Grauer Machine Known parameters: Selling price per unit Fixed cost Variable cost per unit 55 1 2 Technofil Machine 3 4 Known parameters: 5 Selling price per box 6 Fixed cost 7 Variable cost per box 8 9 Input Data 10 Number of boxes, X 11 12 Results 13 Total revenue 14 Fixed cost 15 Total variable cost 16 Total cost 17 Profit 18 19 Input Data Number of boxes, X Results Total revenue Fixed cost Total variable cost Total cost Profit 20 21 22 23 24 25 26 27 28 29 30 31 32 with the exact excel sheet. thank you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started