CC Car Wash specializes in car cleaning services. The services offered by the company, the exact service time, and the resources needed for each of them are described in the table following:

The company offers the following packages to their customers:

• Package 1: Includes only car wash (service A).

• Package 2: Includes car wash and waxing (services A and B).

• Package 3: Car wash, waxing, and wheel cleaning (services A, B, and C).

• Package 4: All four services (A, B, C, and D).

Customers of CC Car Wash visit the station at a constant rate (you can ignore any effects of variability) of 50 customers per day. Of these customers, 30 percent buy Package 1, 30 percent buy Package 2, 15 percent buy Package 3, and 25 percent buy Package 4. The mix does not change over the course of the day. The store operates 10 hours a day.

a. Define “minute of work” as the flow unit, what is the capacity rate of the employee at the interior cleaning step per day? Round the answer to the nearest whole number. For example, if your answer is 2543.65, round to 2544; if you answer is 2543.12, round to 2543.

Your answer is .

b. What is the implied utilization rate for the employee at service C (wheel cleaning)? Round your answer to the nearest whole number and ignore the percentage sign. For example, if your answer is 0.45 or 45%, fill in 45; if your answer is 0.76 or 76%, fill in 76.

Your answer is .

c. What is the implied utilization rate for the automated washing machine? Round your answer to the nearest whole number and ignore the percentage sign. For example, if your answer is 0.45 or 45%, fill in 45; if your answer is 0.76 or 76%, fill in 76.

Your answer is .

d. What resource has the highest utilization rate? Input 1 for washing machine, input 2 for waxing machine, input 3 for employee at C, input 4 for employee at D.

Your answer is .

Please assist with the journal entries

You may use Microsoft access or Derby DB

Please I need an answer for this problem, I have posted this problem 5 times.

Put aggregate without condition for the following 6 queries:

• Queries:

  -- Query 1
  -- Find the details of students who was born after 31st december 2004.
  select * from Student_Information where DOB>"2004-12-31";

  -- Query 2
  -- Find all student details whose first name begins with J.
  select * from Student_Information where FirstName like 'J%';

  -- Query 3
  -- Find the total fees for each FeeID.
  select FeeID,(OrientationFee+CampusFee+LabFee+CommencementsFee) as "Total Fees" from Fees;

  -- Query 4
  -- Find all subject IDs whose Subject1 is botany.
  select subjectID from Subjects where Subject1="Botany";

  -- Query 5
  -- Find all gradeIDs with 10 points for both quiz and exam.
  select GradeID from Grades where Quizzes=10 and exams=10;

  -- Query 6
  -- Find the feeid and orientation fees where orientation fees is beween 500 and 1300
  select FeeId,OrientationFee from Fees where OrientationFee BETWEEN 500 AND 1300;

Schema:

Student's Information

Fees

Subjects

Grades

Student’s Information (ID, Firstname, Lastname, DOB);

Fees (ID, Orientationfees, Campusfees, Labfees, Commencementfees);

Subjects (ID, Subject1, Subject2, Subject3, Subject4);

Grades (ID, Quizzes, Classwork, Homework, Exams, Finalgrade);

Student's Information

Fees

Subjects

Grades

Perez Computers Incorporated grants its customers cash discounts of 3/10, n/60. Perez had the following transactions during the month of July.

Instructions: Journalize these transactions for the seller using the gross method of accounting for sales.

Instructions: Journalize these transactions for Perez Computers Incorporated using the net method of accounting for sales.

1) Describe what makes a cost “relevant” when making a decision between two alternatives.

2)Imagine you are a manager of a snack food company. You need to make a decision whether you should manufacture a new cheese curl or purchase it from another manufacturer and re-sell it to your customers.   Discuss what factors are relevant in this decision and how you would make the right decision.

3) What is a constraint in a manufacturing process? Why does it make sense to concentrate on contribution margin relative to the constrained resource instead of contribution margin per unit in these cases?

The FAX of Life Company is considering the purchase of 100 FAX machines which will be leased to a convenience store chain. Individual convenience stores will then charge a small fee for the use of the machine by customers. The FAX machines will cost $70,000 and will be sold at the end of four years for the estimated $16,000 salvage value. The annual cash inflow from leasing the machines is expected to be $20,000. The income tax rate is 25%. The cost of capital is 12%.

Calculate the answer for each of the following capital budgeting methods. 1. Net Present Value 2. Internal Rate of Return 3. Payback Period 4. Accountant's Rate of Return

1: Use the customers table inside of the salesordersexample database, and write a query statement to show records from the CustFirstName, CustLastName, and CustCity columns.

2:  Use the employees table inside of the salesordersexample database, and write a query statement to show the employee’s EmployeeID, EmpFirstName, EmpLastName, and EmpPhoneNumber, if the employee is living in the 98413 zip code.

3. Use INNER JOIN to create a query result. In this query result, list each vendor’s name and the name of each product the vendor has supplied to our company. You should use the Vendors, Product_Vendors, and the Products tables in the database to complete this task.  

A power company operates three power generation plants. One is a wind plant, and the other two consume a combination of Fuel 1 and Fuel 2, emitting carbon dioxide in the process. In addition, all three plants require maintenance. The amount of fuel consumed (in Mg), maintenance required (in person-hours), carbon dioxide (CO2) emitted (in Mg), and power generated (in MWh) per day of operation is as follows: Maintenance Fuel 1 Fuel 2 CO2 Power Plant Required Required Required Emitted Produced 1 20 0 0 0 20 2 13 10 15 12 32 3 18 30 40 29 40 Each MWh of power can be sold at £121 and there is no limit on the amount that can be sold. Over its next planning period, the company has 230 person-hours for maintenance, 75 Mg of Fuel 1, and 90 Mg of Fuel 2 available.

(a) Due to environmental regulations, they cannot emit more than 200Mg of CO2 in this period. The company wants to know how to operate its plants to generate as much revenue as possible (you may assume that there is no limit on the number of days a plant can operate in this period). Give a linear program that models this problem and state what each of your variables is meant to represent. You do not need to solve this program. [11]

(b) Suppose now that the company can emit more than 200Mg of CO2, but now loses £55 of revenue for each Mg emitted after the first 200Mg because it must purchase “CO2 credits”. The other resource constraints remain as stated. The company now wants to know how to operate its plants to generate as much revenue as possible (you may assume that there is no limit on the number of days that a plant can operate in this period). Give a linear program that models this problem. You do not need to solve this program.

The nominal price (per pound) of apples for each year is shown in the timeline below.

What is the real price of apples in year 2002 (as seen from year 2001).

Calculate your answer to the nearest penny (e.g., 3.81)

The nominal price (per pound) of apples for each year is shown in the timeline below. What is the real price of apples in year 2002 (as seen from year 2001). Calculate your answer to the nearest penny (e.g., 3.81) Year 2001 2002 2003 2004 Nominal Price $2.38 $2.51 $2.62 $2.76 Price Level 151 155 157 160 Price Adjustment Real Price