Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribedwith the exact excel sheet. thank you
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting and Reporting

Authors: Barry Elliott, Jamie Elliott

14th Edition

978-0273744535, 273744445, 273744534, 978-0273744443

More Books

Students also viewed these Accounting questions