Please include excel formula Parker & Stone, Inc., is looking at setting up a new manufacturing plant in South Park to produce garden tools. The company bought some land six years ago for $2.8 million in anticipation of using it as a warehouse and distribution site, but the company has since decided to rent these facilities from a competitor instead. If the land were sold today, the company would net $3.2 million. The company wants to build its new manufacturing plant on this land; the plant will cost $14.3 million to build, and the site requires $825,000 worth of grading before it is suitable for construction. What is the proper cash flow amount to use as the initial investment in fixed assets when evaluating this project? Input area:

A company uses 5000 items per annum which has a price of $2 each. The ordering costs are $150 per order and holding costs are $1.50 per item per annum. The company is offered a 5% discount (discounted price is $1.90) for orders of 5000 and over. Order cost and holding cost remain at $150 per order and $1.50 respectively. Assuming that the company orders 5000 items per order, calculate the number of orders per annum, average stock, annual stock holding cost, annual order cost, annual inventory cost and the total annual cost of items and inventory.

I need help with part 2 please. Thank you Bob Downe is auditing Red Cedar Office Furniture (RCOF), a manufacturer of office furniture and custom cabinets. RCOF was founded 25 years ago by a husband-and-wife team and has grown rapidly in the last five years as solid, environmentally friendly wooden furniture has grown in popularity. The company has inventory consisting of raw materials, work in process, and finished goods with a book value of $6,719,028.95.You have been assigned the task of testing the accuracy of the final inventory compilation for RCOF. You may assume that you have separately observed the inventory and that you are satisfied that the inventory was accurately counted. However, you need to test that quantities were accurately transcribed to the final accumulation and valuation of inventory and that the inventory is correctly priced and accumulated. A file showing the client’s accumulation of inventory is available in Wiley Course Resources.This case will guide you…

The Vintage Restaurant, on Captiva Island near Fort Myers, Florida, is owned and operated by Karen Payne. The restaurant just completed its third year of operation. Since opening her restaurant, Karen has sought to establish a reputation for the Vintage as a high-quality dining establishment that specializes in fresh seafood. Through the efforts of Karen and her staff, her restaurant has become one of the best and fastest growing restaurants on the island. To better plan for future growth of the restaurant, Karen needs to develop a system that will enable her to forecast food and beverage sales by month for up to one year in advance. Table 17.25 shows the value of food and beverage sales ($1000s) for the first three years of operation.  Dependent variable: What is the variable: ___________________________________________ How it is measured, i.e. what units or categories are used (e.g., revenue measured in “dollars”; height measured as “short, average, tall”)…