Toby wants to calculate her COGS for a fertilizing job she did last week. She used 40 pounds of fertilizer that she bought in bulk ($1,000 for 2,000 pounds). It took her employee 1.5 hours to spread the fertilizer (she is paid $15/hour) with the motorized spreader. Toby paid $4,000 for the spreader three years ago and it is estimated to last 10 years or 10,000 pounds. To get to the job site, a company truck and trailer was used (cost: $40,000 expected to last 10 years or 200,000 miles, the site visit was 30 miles round trip). This was the only use of the truck, trailer, and spreader for that day. Additional employee costs include 10% payroll tax and $730 per year in worker’s compensation insurance. You may assume an employee works 2000 hours per year.

Construct a balance sheet and income statement and include calculations done by formula within Excel (include cell references). Separate and label the parts of the calculation as Direct Material (DM), Direct Labor (DL), or Overhead (OH). Please make two calculations comparing the straight-line depreciation method with the units of production method.

For Exercises 49–52, identify the independent and dependent variables for each study.

49.A study was conducted to determine if crocodiles raised in captivity (i.e., in a zoo) grew faster than crocodiles living in the wild. Identify the explanatory variable and the outcome variable.

50.People who walk at least 3 miles a day are randomly selected, and their blood triglyceride levels are measured in order to determine if the number of miles that they walk has any influence on these levels.

51.In an article in the British Journal of Nutrition, two types of mice were randomly selected. One group received a thyme supplement for a specific time, while another group was used as a control group and received no supplements. The brains of the mice were then analyzed, and it was found that the brains of the group of mice that received the thyme supplements had antioxidant levels similar to those of younger mice. It was concluded that the thyme supplement increased the antioxidants in the brains of the mice.

52.A study was conducted to determine if workers who had a flexible work schedule had greater job satisfaction than those workers who worked a regular nine-to-five work schedule. Independent variable—type of work schedule.

Question 1

A local government board hired you to recommend which of the two possible sites should be chosen for a new recycling facility. Location A is much closer to the city center, and thus the average hauling distance would only be 2 miles, while Location B being outside of the city would result in an average hauling distance of 5 miles. Public funds will have to be used to pay for the leasing cost of the site, which would be $50,000 a year for Location A and $10,000 a year for Location B, as well as for the hauling cost which is $200 per mile for each trip. Assuming 3,000 trips will be made per year, which location should be chosen based on the overall cost?

Question 2 :

Metal ABC produces sheets of metal. Its fixed cost in year 2019 is $1,000,000. The variable cost is $400 per sheet. a. Find the break-even quantity assuming the selling price is $500 per sheet. b. Find the price and quantity that will result in maximum profit, assuming the demand function is ? = $10,000 − 6?. How much profit will be made using the profit-maximizing price and quantity values?

JAVA please

Program 4: Is there a Prius version? Did you know that the average Boeing 747 airplane uses approximately 1 gallon of fuel per second? Given the speed of the airplane, that means it gets 5 gallons to the mile. No, not 5 miles to the gallon, 5 gallons to the mile. You may be questioning why such a horribly inefficient machine is allowed to exist, but you’ll be happy to find out that, because this airplane hold 568 people, it averages about 0.01 gallons per person – (100 miles per gallon per person). Your job is to design (pseudocode) and implement (source code) a program that asks the user for a distance the plane has to fly (i.e. the length of the trip) and also asks the cost of jet fuel (which is currently $1.80 per gallon). The program should then calculate the total fuel charges to make the trip. Next, ask the user how many people will fly, as well as the average cost of a ticket. Finally, print the total profit made (or lost) and the average gas mileage per person. Document your code and properly label the input prompts and the outputs as shown below.

5. You are preparing a project to lay fiber optic cable. The first task is to mobilize the team. You estimate this will take one week and cost $4000. The second task is to lay the cable. This will take three weeks and will cost $30,000. The total length of the cable is 15 miles. The last task, which will take one week, is to terminate and test the cable. You budget $6000 for this. At the end of the first week, you have completed mobilization, but it cost a total of $4500. At the end of the third week, you have completed five miles of cable at a total cost of $28,000 (installation only). It takes you a total of 10 weeks to complete the entire project, for a total cost of $75,000.

a. At the end of week 1: i. What is your SPI? ii. What is your CPI? iii. What is your EAC?

b. At the end of week 3: i. What is your SPI? ii. What is your CPI? iii. What is your EAC?

c. At the end of the project: i. What is your SPI? ii. What is your CPI? iii. What is your EAC?

Can someone show me how to do this on Excel?

Thanks

Full Limo Inc. offers high-end transportation services between the King of Prussia Mall (KPM) and Center City Philadelphia (22.5 miles). The invested capital is $800,000, corresponding to the investment in the 4 luxury vans it owns (you can ignore all other invested capital). Each van can carry 10 passengers. Each van makes 12 daily trips from Philadelphia to KPM and 12 from KPM to Philadelphia. The company charges $10 for each one-way ride. The current load factor is 40% (that is, each ride has 4 passengers on average). A significant source of operating costs is the fuel cost. The company vans have a fuel economy of each of 20 mpg (miles/gallon). Current fuel prices are 2.629 $/gallon. The staff costs and other costs of operating the service and running the business are $1M per year. The company operates 365 days a year.

a) Draw an ROIC (return on invested capital) tree for the company.

b) What is the ROIC?

c) Assume that the company can increase the fuel efficiency of the vans to 25mpg. What would be the new ROIC?

1)

The risk free rate on treasury bills is 2.40%. Inflation is 1.3%. What is the real rate of return on treasury bills?

Meaning of what is the "real rate of return" ?

If investor saw calculated number two from above, would he be pleased or not?

2)

The nominal return on treasury bonds is 2.7%, the maturity risk premium is 0.2%. Real return can earn 0.3%.

What is the inflation premium?

Why is there maturity risk premium on US treasury bonds vs. bills?

1. Assume the rate of return given below are for two stocks listed on the Ghana

          Stock Exchange (GSE).

1. Calculate the arithmetic average return on the two stocks over the 5-year period.
2. Which of the two stocks has a greater dispersion around the mean?
3. Calculate the geometric average returns of each stock.