Your company has a travel policy that reimburses employees for the “ordinary and necessary” costs of business travel. Employees often mix a business trip with pleasure by either extending the time at the destination or traveling from the business destination to a nearby resort or other personal destination. When this happens, an allocation must be made between the business and personal portions of the trip. However, the travel policy is unclear on the allocation method to follow.

Consider this example. An employee obtained a business-class ticket for $9,558 and traveled the following itinerary:

On the date of the flights between Chicago and Paris (and return), a restricted round-trip fare of $4,980 was available.

Required:

a. Compute the business portion of the airfare and state the basis for the indicated allocation that is appropriate according to each of the following independent scenarios:

1. Based on the maximum reimbursement for the employee.

2. Based on the minimum cost to the company.

For this portion of the lab you will design the solution so that you perform some conditional tests. For this lab: 1. You will validate input to ensure that the user enters inputs within a certain range or larger than a certain minimum value. You will validate the inputs as follows: (LO 1, 2, 3) a. The user cannot enter a negative number for: i. Miles to kilometers ii. Gallons to liters iii. Pounds to kilograms iv. Inches to centimeters b. The user cannot enter a value above 1000 degrees for Fahrenheit to Celsius (LO1) c. You MUST design a logical program exit. You may NOT use exit, break, quit, or system exit, or ANY OTHER forced exit. Do not use a menu. Use LOGIC to exit the program. 2. If the user enters an invalid value, then the program will issue an error message and terminate immediately. (Do NOT accept further data). 3. Save the program as firstname_lastname_Lab3a.py where you will replace firstname and lastname with your actual first and last name. 4. Test all conditions prior to submitting.

Tidwell Industries has the following overhead costs and cost drivers. Direct labor hours are estimated at 100,000 for the year.

Activity Cost Pool                Cost Driver          Est. Overhead           Cost Driver Activity

Ordering and Receiving         Orders                    $   120,000               500 orders

Machine Setup                     Setups                        297,000               450 setups

Machining                             Machine hours         1,500,000               125,000 MH

Assembly                              Parts                        1,200,000               1,000,000 parts

Inspection                             Inspections                 300,000               500 inspections

If overhead is applied using traditional costing based on direct labor hours, the overhead application rate is

a.   $9.60.

b.   $12.00.

c.   $15.00.

d.   $34.17.

In applying the high-low method, what is the unit variable cost?

Month                Miles                Total Cost

January             80,000               $192,000

February           50,000                 160,000

March               70,000                 158,000

April                  90,000                 260,000

a.   $2.88

b.   $2.50

c.   $3.20

d.   Cannot be determined from the information given.

Continue on previous question. In applying the high-low method, what is the fixed cost?

a.   $35,000

b.   $72,000

c.   $28,000

d.   $100,000

QUESTION 1. Kroger management and Meijer management decide to have a sit down face to face meeting. The Kroger people agree NOT to open any stores north of the stores in Midland and Mt. Pleasant. Further, any new stores that will be opened in Michigan will not be within 12 miles of any Meijer Stores. In exchange, Meijer agrees NOT to open any stores in Indiana. Further, Meijer agrees NOT to open any stores west of the western border of Ohio and to stay out of the Southwest area of Michigan from St. Joe’s to Big Rapids.

You work for IGA and you hear rumors about this agreement between your competitors. You consult with your friends at Wal-Mart and they have not only heard the same rumors, but, they have obtained documentation evidencing the agreement. You, acting on behalf of IGA as well as a rep from Wal-Mart, contact Tom Terrific, (TT), your favorite anti-trust attorney. Please share with us what advice he gave you as well as any specific cases, statutes, or principals of law in support of the attorney’s position.

Suppose frank has estimated a cross sectional regression model for demand for gasoline by state: PCONi = 389.6 + 60.8 UHMi - 36.5TAXi - 0.061REGi T Stat : 5.92 -2.77 -1.43 N =50 R2 = .919 Where: PCONi = petroleum consumption in the ith state (trillions of BTUs). UHMi = urban highway miles within the ith state. TAXi = the gasoline tax rate in the ith state (cents per gallon). REGi = motor vehicle registration in the ith state (in thousands)

a. What do you expect the signs of the explanatory variables to be? Explain why.

b. According to the estimated equation, motor vehicle registrations variable is insignificant and it has a negative sign. Does this make sense to you? Why or why not. Explain carefully.

c. Suppose the simple correlation coefficient between REG and UHM is 0.98. What do you infer from that? In light of this added information, what, if anything you would do and why? What would you expect to find?

d. What is VIF? (Not related to above)

e. What is heteroschedasticity? (Not related to above)

Beate Klingenberg manages a​ Poughkeepsie, New​ York, movie theater complex called Cinema 8. Each of the eight auditoriums plays a different​ film; the schedule staggers starting times to avoid the large crowds that would occur if all eight movies started at the same time. The theater has a single ticket booth and a cashier who can maintain an average service rate of

280 patrons per hour. Service times are assumed to follow a negative exponential distribution. Arrivals on a normally active day are Poisson distributed and average 200

per hour.

a) Find the average number of moviegoers waiting in line to purchase a ticket.
b) What percentage of the time is the cashier busy?
c) What is the average time that a customer spends in the system?
d) What is the average time spent waiting in line to get to the ticket window?
e) What is the probability that there are more than two people in the system? More than three people? More than four?

Problem 13-12 Coefficient of variation and investment decision [LO13-1]

Kyle’s Shoe Stores Inc. is considering opening an additional suburban outlet. An aftertax expected cash flow of $120 per week is anticipated from two stores that are being evaluated. Both stores have positive net present values.

a. Compute the coefficient of variation for each site. (Do not round intermediate calculations. Round your answers to 3 decimal places.)

/*explain */ Select *

From Student join enrollment on student.ID = enrollment.Student_ID

            join section on section.ID = enrollment.section_ID

            join department on major = department.name

            join faculty on faculty.id = section.faculty_ID

            join address on address.id = student.address_ID

            join Course on section.course_Number = course.course_number and section.dept_id = course.dept_ID

Where

--we want to make sure we have name information for students if we want to reach out to them

Student.Name_Last Not Like ('')

-- the theater department has asked to be out of this study

and Student.Major <> 'Theater'

--no students who have failed as we're looking for passing grades

and Grade > '1.33'

--we want to make sure we only have instructors, and the theater department is not part of this study

and Faculty.job in

            (Select job

            From Faculty

            Where Job not in ('Administrative','General Services','Human Resources')

            and Dept <> 'THT')

and Section_ID >=1

--summer courses don't always reflect accurately given their tight schedule and rapid fire delivery of materials

and Semester <> 'Summer'

--we don't want bias of an adivosr giving better grades

and Student.Advisor_ID <> Section.Faculty_ID

-- we don't want bias if a student is possibly a faculty members child

and Student.Address_ID <> Faculty.Address_ID

Order by Student.Name_Last, Grade desc, Faculty.Name_Last, Major

1. Based on the output from the explain command, determine the steps you would take (building indexes on certain columns, modifying the query, both, etc.) to get the same output, but improve overall performance.
2. Execute three steps that you think would make for improvement in the performance of this query. Report their run time in the table below.

Evaluate the impact of the steps you took, what their potential benefits and setbacks may be, and what you would advise as the next steps to improve the performance of this query.

Let X have a binomial distribution with parameters

n = 25

and p. Calculate each of the following probabilities using the normal approximation (with the continuity correction) for the cases

p = 0.5, 0.6, and 0.8

and compare to the exact binomial probabilities calculated directly from the formula for

b(x; n, p).

(Round your answers to four decimal places.)

(a)

P(15 ≤ X ≤ 20)

Below are percentages for annual sales growth and net sales attributed to loyalty card usage at 74 Noodles & Company restaurants.

(b) Find the correlation coefficient. (Round your answer to 3 decimal places. A negative value should be indicated by a minus sign.)
  
r           

(c-1) To test the correlation coefficient for significance at α = 0.1, fill in the following. (Use the rounded value of the correlation coefficient from part b in all calculations. For final answers, round t_calc to 3 decimal places and the p-value to 4 decimal places. Negative values should be indicated by a minus sign.)

(c-2) There is no significant correlation.
  

• False

• True

(d) Does it appear that increased loyalty card usage is associated with decreased sales growth?
  

• Yes

• No

Next