The Gatson manufacturing company has estimated the following components for a new product.
Fixed cost = $50,000 Material cost per unit = $2.15 Labor cost per unit = $2.00 Revenue per unit = $7.50
Round your answer to the nearest whole number.
1. Using a spreadsheet model, what will be the resulting profit if the company decides to make 70,000 units of the new product?
2. Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit is zero. Vary production volume from 0 to 100,000 in increments of 10,000. In which interval of production volume does breakeven occur?
3. Using the appropriate Excel tool, find the exact breakeven point.
Please interpret the results and solve using excel.
Alpha Computer Company applies for an LC from Small Business Bank to import 35.000 component parts from its suppliers in Taiwan for the next 12 months. The component arts...May 04 2021
The first step in Hamel’s wheel of innovation is .(a) imagining(b) assessing (c) experimenting(d) scalingJul 18 2020
Consider a corporation who recently filed Chapter 11 bankruptcy (reorganization). Under the reorganization, the company has been allowed to reorganize their debt structur...May 27 2021
Total revenue decreases if price and demand is Not yet answered Marked out of 1.00 P Flag question Select one: o a. falls; elastic o b. falls; unit elastic c. rises; inel...Apr 05 2021
The production department of the newspaper has embarked on a quality improvement effort and has chosen as its first project an issue that relates to the blackness of the ...May 16 2018
You have a cousin who lives in a small town in eastern Kansas. She just told you that her friend has a 4-year-old daughter with cancer—a rare form of leukemia—who needs m...Aug 12 2021
Quality at the Ritz-Carlton Hotel CompanyRitz-Carlton. The name alone evokes images of luxury and quality. As the first hotel company to win the Malcolm Baldrige National...Jul 31 2020
Why do I have three Norton Internet Security icons in my task-bar?Apr 18 2020
An investor shorts 500 Woolworths shares when the share price is $42.46 and closes out the position six months later when the share price is $48.68. The shares paid a div...Apr 13 2021
Direct control is the control that is exercised after the deviations from plans have occurred. Which of the following is not the underlying assumption of direct control? ...Dec 18 2017