
1. "Car Parts Emporium" is getting ready to expand and is looking at buying some robotic...
Solve using excel Q: Fx, Inc. is a volume manufacturer of high technology automotive mirrors (including cell and voice activation). FX is looking to expand their operations to add a second product line capable of producing 1.3 Million units per year. The equipment investment cost for this new operation is $23Million. The project falls under a 7-year MACRS class life, and the company estimates that the salvage value will be $2.7 Million at the end of the 6-year project. The...
Problem 1 The XYZ Tile Co. has decided to secure its tile clay from a property owned by John Doe, adjacent to the tile plant. The company has made a royalty contract with Mr. Doe according to which Doe's holdings will supply the company's need of 200,000 tons per year for the next 15 years before the clay is exhausted. For the first five years, the company will pay a royalty of $1 per ton of clay. For the next...
Shaftel Ready Mix is a processor and supplier of concrete,
aggregate, and rock products. The company operates in the
intermountain western United States. Currently, Shaftel has 14
cement- processing plants and a labor force of more than 375
employees. With the exception of cement powder, all materials
(e.g., aggregates and sand) are produced internally by the company.
The demand for concrete and aggregates has been growing steadily
nationally. In the West, the growth rate has been above the
national average....
Assistance needed with looking at what system would match Company A and B and why. You are a consultant supporting two different businesses on a consulting assignment where they are asking you to review two Talent Management systems to support their respective businesses and make a recommendation as to which of the systems they should chose to support their needs. The company has created a short list of systems from which you are to select two to assess: Workday HCM,...
СKG Auto compact car manufacturing assembly plants rely on parts from multiple outside vendors and internal subassembly plants. Currently, these parts are all transported via independent trucking firms for negotiated fees based on actual tons shipped and miles. The operations management group has been dissatisfied lately with the service levels provided by these outside trucking companies, as well as with the rising costs of roughly 6.0% per year for the last two years. These costs are expected to rise in...
Refer to Table 1. Write the Excel formula for each cell marked with “?” in columns B, C and D such that formula could be copied and pasted into columns D, E, F and G using Microsoft Excel without further editing. There is no need to explicitly write the Excel formula for cells marked with “Copy & paste”. Label each formula clearly with cell reference position. In 2020, BS Bank employs 800 employees in its call centres in the United States...
Saxon Products, Inc., is investigating the purchase of a robot for use on the company’s assembly line. Selected data relating to the robot are provided below: Cost of the robot $ 2,000,000 Installation and software $ 490,000 Annual savings in inventory carrying costs $ 218,000 Annual increase in power and maintenance costs $ 38,000 Salvage value in 5 years $ 78,000 Useful life 5 years In addition to the data above, engineering studies suggest that use of the robot will...
a) Problem 1: What is your total for Inventory? See
circle on the printed exercise.
b) Problem 1: What is your total for Net Income? See
circle.
c) Problem 2: What is your total for Cost of Goods Sold?
See circle.
d) Problem 2: What is your total for Net Income? See
circle.
e) Problem 2: What is your total for Ending Inventory
(in dollars)?
Instructions: Use the horizontal analysis on the next page to record the following transactions. Remember,...
Background: During your first business class, you saw the opportunity to bring white paper squares to the Salisbury University market. On a whim, you started manufacturing low quality, thin, white, flexible squares of paper. Shockingly, your business took off and the company was successful in competing in a saturated market. Seeing the need for diversification, you launched a new specialty product with the hope of increasing sales and setting the business apart. With moderately good recording keeping and a solid...
Comprehensive Accounting Cycle Review Journalize transactions and prepare financial statements. ACR13 Karen Noonan opened Clean Sweep Inc. on February 1, 2020. During February, the following transactions were completed. Feb. 1 Issued 5,000 shares of Clean Sweep common stock for $13,000. Each share has a $1.50 par. I Borrowed $8,000 on a 2-year, 6% note payable. Paid $9,020 to purchase used floor and window cleaning equipment from a company going out of business ($4,820 was for the floor equipment and $4,200...