An employee of a small software company in Minneapolis bikes to work during the summer months. He can travel to work using one of three routes and wonders whether the average commute times (in minutes) differ between the three routes. He obtains the following data after traveling each route for one week.

Route 1 34 35 29 36 29

Route 2 21 28 25 30 24

Route 3 22 27 25 30 26

a-1. Construct an ANOVA table.

a-2. At the 1% significance level, do the average commute times differ significantly between the three routes. Assume that commute times are normally distributed.

b. Use Tukey’s HSD method at the 1% significance level to determine which routes' average times differ.

Following is partial information for the income statement of Audio Solutions Company under three different inventory costing methods, assuming the use of a periodic inventory system:

Required:

1. Compute cost of goods sold under the FIFO, LIFO, and average cost inventory costing methods. (Round intermediate calculations to 2 decimal places. Round your answers to the nearest whole dollar amount.)

2. Prepare an income statement through pretax income for each method.

Sales, 328 units; unit sales price, $53; Expenses, $1,640

3. Rank the three methods in order of income taxes paid (favorable cash flow).

The Bensington Glass Company entered into a loan agreement with the​ firm's bank to finance the​ firm's working capital. The loan called for a floating rate that was 27 basis points ​(0.270.27 percent) over an index based on LIBOR. In​ addition, the loan adjusted weekly based on the closing value of the index for the previous week and had a maximum annual rate of 2.16 percent and a minimum of 1.71 percent. Calculate the rate of interest for weeks 2 through 9

The rate of interest for week 2 is %.
​(Round to two decimal​ places.)

Miller Manufacturing builds and markets laptop computers for home and small business use. During the past five years, sales have been as low as 10,000 units in a year and as high as 15,000 units in a year. The company has been approached by an outside supplier offering to provide completed screens to the company for $65 each. The company’s marketing director negotiated the deal personally and is thrilled about how much cheaper it will be to purchase the screens from outside. Producing the cost data outlined below, the manager proudly proclaims, “Look, a $25 per unit savings!”

Per

[Based on 15,000 units year] Unit

Direct materials $40

Direct labor 10

Variable manufacturing overhead 3

Fixed manufacturing overhead, direct 10

Fixed manufacturing overhead, indirect 27

Total cost $90

Assume that Miller Manufacturing determines that sales in future years will be 15,000 units per year. IF the company decides to BUY the screens from the outside supplier, what will be the impact on annual company net income?

Company net income will INCREASE by $30,000 if the company decides to buy the screens from the outside supplier.

Company net income will DECREASE by $30,000 if the company decides to buy the screens from the outside supplier.

Company net income will INCREASE by $375,000 if the company decides to buy the screens from the outside supplier.

Company net income will DECREASE by $375,000 if the company decides to buy the screens from the outside supplier.

Company net income will INCREASE by $225,000 if the company decides to buy the screens from the outside supplier.

Company net income will DECREASE by $225,000 if the company decides to buy the screens from the outside supplier.

Miller Manufacturing builds and markets laptop computers for home and small business use. During the past five years, sales have been as low as 10,000 units in a year and as high as 15,000 units in a year. The company has been approached by an outside supplier offering to provide completed screens to the company for $65 each. The company’s marketing director negotiated the deal personally and is thrilled about how much cheaper it will be to purchase the screens from outside. Producing the cost data outlined below, the manager proudly proclaims, “Look, a $25 per unit savings!”

Per [Based on 15,000 units year] Unit

Direct materials $40

Direct labor 10

Variable manufacturing overhead 3

Fixed manufacturing overhead,direct 10

Fixed manufacturing overhead, indirect 27

Total cost $90

Assume that Miller Manufacturing determines that sales in future years will be 12,000 units per year. IF the company decides to BUY the screens from the outside supplier, what will be the impact on annual company net income?

Company net income will INCREASE by $300,000 if the company decides to buy the screens from the outside supplier.

Company net income will DECREASE by $30,000 if the company decides to buy the screens from the outside supplier.

Company net income will INCREASE by $30,000 if the company decides to buy the screens from the outside supplier.

Company net income will DECREASE by $6,000 if the company decides to buy the screens from the outside supplier.

Company net income will INCREASE by $6,000 if the company decides to buy the screens from the outside supplier.

Company net income will DECREASE by $300,000 if the company decides to buy the screens from the outside supplier.

Questins!!!!

Risks: Describe the risks that Koala Fun faced as a company.

Management: In what ways was Koala Fun not being managed to obtain optimum performance from its assets?

Explain. Decisions: How does this case demonstrate the importance of analyzing financial data when making financial decisions?

Recommendations: What recommendations regarding risk and profitability would you make to Koala Fun’s owners to improve their company? Briefly describe your recommendations.

FINANCIAL CONCERNS Owen and Tessa loved their company but were inexperienced in business matters. Owen asked his mother, Amy, an accountant, for assistance. After studying the ledgers and other records, she reported that there was a signifi- cant working capital problem with declining cash, unsold inventory (mostly old Koala Fun games), and vendors who had not been paid. Tessa had been handling this side of the company, but that had mostly involved writing checks to employees and for payables while waiting around airports. Files were misplaced, documents were missing, and some money was unaccounted for. The problems appeared to be more related to failing to priori- tize financial matters rather than any deliberate mistakes. Owen’s first reaction was to consider the sale of his half interest in KF. Though he has enjoyed the creative side of the business, he was upset by his mother’s report and by Tessa’s apparent failure to take care of that responsibil- ity. Periodically, some of the resellers KF deals with have encountered finan- cial problems and have strung out their payments, which often caused a mad scramble for cash at KF. And if Owen decides to sell, he knows that he is likely provide it.” Owen is skeptical of this argument and wonders if there isn’t a more efficient way of providing good service. He also questions Tessa’s credit standards and collection procedures, and believes that Tessa has been quite generous in granting payment extensions to customers. At one point, nearly 45 percent of the company’s receivables were more than 90 days overdue. Furthermore, Tessa would continue to accept and ship orders to these resellers even when it was clear that their ability to pay was marginal. Tessa’s position is that she doesn’t want to lose sales and that the difficult times are only temporary. Owen wonders about the wisdom of passing up trade discounts. Vendors frequently offer KF terms of 11?2/10, net 30. That is, KF receives a 11?2 percent discount if a bill is paid in 10 days and in any event full payment is expected within 30 days. Tessa rarely takes these discounts because she “wants to hold onto our cash as long as possible.” She also notes that “the discount isn’t espe- cially generous and 981?2 percent of the bill must still be paid.” FINAL THOUGHTS Despite all of Owen’s concerns, however, the relationship between the two partners has been relatively smooth over the years. And he admits that he may be unduly critical of Tessa’s management decisions. “After all,” he concedes, “she seems to have reasons for what she does, and we have never lost money since we started, which is an impressive record, really, for a firm in our business.” Owen has discussed with two advisors the possibility of selling his half of the firm. Since KF is not publicly traded, the market value of the company’s stock must be estimated. The consultants believe that KF is worth between $35 and $40 per share, figures that appear reasonable to Owen.

Data Mining - Milestone One

Page length requirements: One Paragraph

Question: Based on the scenerio below: What is the purpose of the analytic method/approach/strategy you are using? What typeof information does it yield?

The scenario: Bubba Gump Shrimp Company is a successful retailer of regional food, both in its restaurants and through other retail channels. Bubba Gump began as a small, privately owned restaurant. Thanks to unexpected exposure from a blockbuster movie, Bubba Gump grew rapidly from its humble beginnings and now operates several restaurants, sells branded merchandise through an online retail site, and wholesales its branded merchandise to other retail outlets. Bubba Gump's growth was initially very rapid in response to a strong demand and high name recognition that followed from its movie exposure. After its first few years of rapid growth, sales increased at slower rates and finally leveled off. Sales have declined in each of the last two years. Bubba Gump Shrimp Company has collected a large amount of data about its business, including restaurant point-of-sale (POS) data, web channel sales performance, customer information through restaurant loyalty programs, and customer and sales transaction data through its website and retail partners. Bubba Gump's leadership has decided to commission an analysis of the company's vast data assets to better understand its customers and look for ways to create new revenue growth. You have been assigned to plan, conduct, and report on this data mining initiative for Bubba Gump Shrimp Company. The company data that is available to you includes Bubba Gump's restaurant point-of-sale (cash register, credit card) data, its customer database (collected from its restaurant loyalty program and online sales channel), its web store sales transaction data, and customer and sales data from third-party retailers. All of Bubba Gump's data has recently been integrated in a data warehouse. That enterprise data warehouse was built specifically to support data mining initiatives like the one you have been assigned to conduct, by consolidating data from multiple operations and channels in one place and integrating the data across sources for a complete view of the customer experience. For the first time, Bubba Gump analysts can link sales transactions to specific customers at specific restaurants, for example. It also means that you can link customer transactions across channels; that is, for any given customer, you can link to both their restaurant purchases, their online purchases, and (in some cases) their purchases from third-party retail partners. You have been selected to develop and execute the data mining analysis plan for Bubba Gump's customer analysis project. Your project will be the first major data mining project conducted against the new Bubba Gump data warehouse. Because Bubba Gump's data was not previously integrated in a single data warehouse, company leadership has never been able to analyze its customers across their complete experience. In other words, customer restaurant purchases, online purchases, and third-party retailer purchases could not be analyzed together previously; each channel had to be analyzed separately. As a first step, a sample of 500 customers has been selected from the analytics data warehouse and given a survey in exchange for purchase credits at one of Bubba Gump's sales channels. The survey sample was selected from the universe of customers who have made purchases from at least one Bubba Gump outlet (restaurant, web store, etc.). Responses to various customer satisfaction questions were recorded, and historical purchase information has been extracted from the data warehouse for each customer in the sample.

Consider the database of a car rental company that contains three tables drivers, cars and reservation tables.

Drivers:                                           Reservation:                              Cars:

1. Write DDL statements to create the tables

Drivers(Dno, Dname, age)

Reservation(Dno, Cno, Day)

Cars(Cno, Cmake, Color)

Where:

• no field could be empty except the age of the Driver.
• The company does not own more than one car from one maker     
• the colors of the cars should not be other than the following group (blue, white, red , green)

2. Write Queries for the following:
   1. Insert the sample data shown above into the tables

3. Write Queries for the following:
   1. Find the names of drivers who have reserved car no 103.
   2. Find the names of Drivers who have reserved red or Green cars.( use IN, UNION, =SOME/=ALL, and JION    each in separate query)For this segment, 4 responses are required, using the operations shown in parentheses
   3. Find the driver Dno of drivers with age over 20 who have not reserved a read car.
   4. Find the names of drivers who have reserved all cars.
   5. List the name of the drivers along with the day they rent cars in descending order
   6. List the name of the drivers whom rent more than 3 times along with the number of the times.
   7. Change the age of Alice to 18 years old
   8. Delete the information of the drivers younger than 20 years old

Consider the database of a car rental company that contains three tables drivers, cars and reservation tables.

Drivers:                                           Reservation:                              Cars:

1. Write DDL statements to create the tables

Drivers(Dno, Dname, age)

Reservation(Dno, Cno, Day)

Cars(Cno, Cmake, Color)

Where:

• no field could be empty except the age of the Driver.
• The company does not own more than one car from one maker     
• the colors of the cars should not be other than the following group (blue, white, red , green)

2. Write Queries for the following:
   1. Insert the sample data shown above into the tables

3. Write Queries for the following:
   1. Find the names of drivers who have reserved car no 103.
   2. Find the names of Drivers who have reserved red or Green cars.( use IN, UNION, =SOME/=ALL, and JION    each in separate query)For this segment, 4 responses are required, using the operations shown in parentheses
   3. Find the driver Dno of drivers with age over 20 who have not reserved a read car.
   4. Find the names of drivers who have reserved all cars.
   5. List the name of the drivers along with the day they rent cars in descending order
   6. List the name of the drivers whom rent more than 3 times along with the number of the times.
   7. Change the age of Alice to 18 years old
   8. Delete the information of the drivers younger than 20 years old

Python/Thonny - In an office chair store, 3 types are sold: basic, standard and luxury. In addition there are normal customers and frequent customers. The price of the chairs is: Basic $ 700.00 each Standard $ 900.00 each Luxury $ 1,500.00 each The store owner has decided to give a 20% discount to frequent customers. In addition, it has decided to apply the following wholesale discount policy to normal customers: If your purchase is> = $ 10,000 and <$ 20,000 a 10% discount if your purchase is> = $ 20,000 a 15% discount Write a program that asks the type of chair, the type of customer and the quantity to buy (suppose that only one type of chair is to be purchased) and calculate and show: the price before applying discount, the amount of money granted by discount and The total to be paid by the customer.