DP world is a company which creates revenues through two operating departments, the loading/unloading ,Of the $876 million invested by DP World into the Fairview container port, 90 percent ($788.4 million) was invested in the loading/unloading department assets and 5% ($43.8 million) was invested in the container decontamination department assets. The other 5% was invested in corporate office which has an expected zero return. The company expects the loading/unloading department to generate an ROI of 15% per year before tax over the planned 20-year life of the current equipment and expects the container decontamination department to generate an ROI of 7% per year before tax over the planned 25-year life of the current equipment. The methodology that DP World uses to price its services for its shipping customers is to arrive at a cost that includes the ROI plus all applicable costs. Therefore, the total cost per container that is charged to a customer includes total costs plus the required ROI per container. DP World's $200 million expansion readied Fairview to accept the largest vessels at sea, which are increasingly favored by shippers seeking to load more containers to reduce costs. DP World has two operating departments, with the first department called loading/unloading and the second department called container storage. DP World operates 24/7 and is open 365 days per year. DP World has thefollowing container variable overhead costs,The port variable overhead costs are allocated to the operating departments using the direct method. By allocating the port's variable overhead costs, DP World is able to calculate a VMOH cost per container for each department,assume there is 365 days in each year including 2020.

Required: Complete your answers in an Excel document and create a separate tab for each of the following. Use the suggested template structures pictured below. 1) Allocate the Variable Manufacturing Overhead to the two operating departments using the following information. (10 marks

4) Create a tab named Q4. DP World wanted to achieve an overall Return on Investment (ROI) of 14.50 percent (14.50%). Did they achieve it? In a written paragraph in a separate tab called Q4, inform management what the overall ROI was for 2020 in percentage form and in dollars. This should be a professionally written memorandum to Senior Management commenting on the overall achievementon-achievement of expected ROI. (10 marks)

5) Create a tab named Q5. DP World is committed to boosting the terminals capacity by another third by 2022. In paragraph form in the tab called Q5, recommend to management what business department they should concentrate on to improve the bottom line. This should be a professionally written memorandum to Senior Management commenting on what they should focus on to improve the bottom line. Hint: think like a cost accountant. Why are we using the Variable Costing Income Statement Format? What does it highlight? (10 marks)

6) Create a tab named Q6. DP World is highly interested in building the hotel that Rattenbury planned over 100 years before. All of the architectural drawings can be found in the BC Museum archives in Victoria. The building would cost $120 million to build and would have a total of 300 guest suites. For the planned hotel, food services Net Income is projected at $4 million per year, and banquet facilities Net Income is forecast at $1 million per year. Room revenues have not been projected, however costs per room is expected to be 80% of the revenue per room. DP World would expect a yearly ROI of fifteen percent (15%). Should they build it? In paragraph form along with any calculations in a separate tab called Hotel, recommend to management if they should build the hotel and show financial plus any other reasons why or why not. This should be a professionally written memorandum to Senior Management commenting on the viability of the hotel. (10 marks)

7) Optional. Create a tab named Q7.The Titanic II, a close replica of the 1912 Titanic cruise liner will set sail in 2022. The Titanic II is the brainchild of Australian businessman Clive Palmer, who established a shipping company called Blue Star Line in 2012 in order to make the project a reality. The ship is under construction now and is expected to cost $500 million. The new ship will start out in China, where it's currently under construction, traveling to Dubai before picking passengers up in Southampton, England and following the original vessels 1912 route across the Atlantic to New York City. After completing its journey to New York, the Titanic II will circumnavigate the globe, inspiring and enchanting people while attracting unrivaled attention, intrigue, and mystery in every port she visits, stated Palmer. The only Canadian stop on the world tour will be in Prince Rupert as a tribute to Charles Melville Hays. Optional - for 5 bonus marks, in theQ7 tab, explain why you would, or why you would not, sail on the new Titanic. (Maximum mark on the total assignment is 100 marks including the bonus marks).

please don't give up. I really need some help.

DP World has the following container variable overhead costs: Support Departments Port Information Maintenance Services Operating Departments Loading / Container Unloading Decontamination Total Budgeted Port Variable Overhead costs before any interdepartmental cost allocations $9,000,000 $1,800,000 $9,804,000 $274,000 $20,878,000 Support Work Furnished by: Port Maintenance Budgeted labour hours Percentage Information Services Budgeted Computer Hours Percentage 233,600 40.0% 58,400 292,000 50.0% 584,000 100.0% 10.0% 50,000 5,000 10.0% 20,000 40.0% 25,000 50.0% 100.0% The port has become so cost effective that costs are now lower than any other port in North America. The costs for 2020 show the various rates related to the Fairview Container port as follows: Total Costs Totals 3,600 Load / Unload Powered Units 800 $25.00 $48.00 Load / Unload Non- Powered Units 2,400 $8.00 $32.00 Container Decontamination 400 $5.00 $5.00 Containers per day DM Costs per Container DML Costs per Container Variable Manufacturing Allocated Variable Joint Costs (Physical Measure to Load/Unload only) Fixed costs per container Period Operating Costs per Year $36,500,000.00 $30.751 $2,117,000 $30.75 $6,351,000 $10.00 $1,450,000 $9,928,000 Support Departments Port Information Maintenance Services Operating Departments Loading/ Container Unloading Decontamination Total Budgeted Port Variable Overhead costs before any interdepartmental cost allocations $9,000,000 $1,200,000 $9,975,000 $265,000 $20,440,000 Support Work Furnished by: Port Maintenance Budgeted labour hours Percentage Information Services Budgeted Computer Hours Percentage 116,800 20.0% 408,800 70.0% 58,400 10.0% 584,000 100.0% 3,650 10.0% 10,950 30.0% 21,900 60.0% 36,500 100.0% Create a tab named "Q1". Your answer should follow the following template. Hint - the Total for "Container Decontamination Department" is between: $2,400,000