The Transactional Records Access Clearinghouse at Syracuse University reported data showing the chance of an Internal Revenue Service (IRS) audit. The data in file IRSAudit.xlsx show the average adjusted gross income reported (in $ thousands) and the percent of the returns that were audited for 20 selected IRS districts.

1. Use XLSTAT to compute a 95% confidence interval for the average percent audited of districts with an average adjusted gross income of $35,000. Interpret the interval in the context of the application.

Hint: Enter “35000” into cell B22 in the IRSAudit worksheet. Then, follow the XLSTAT directions in part (b) but before clicking “OK,” click the “Prediction” tab and select cell B22 for “X / Explanatory variables: Quantitative.” You will find the 95% confidence interval at the bottom of the XLSTAT regression output under “Lower bound 95% (Mean)” and “Upper bound 95% (Mean).”

2. Use XLSTAT to compute a 95% prediction interval for the percent audited of an individual district with an average adjusted gross income of $35,000. Interpret the interval in the context of the application.

Hint: You will find the 95% prediction interval at the bottom of the XLSTAT regression output under “Lower bound 95% (Observation)” and “Upper bound 95% (Observation).”

3. Use the regression output in XLSTAT to calculate the coefficient of determination, r2r2 from the sum of squares due to regression (SSR) and the total sum of squares (SST). Interpret your calculated value of r2r2 in the context of the application.

Hint: Find SSR and SST in the Analysis of variance table in the XLSTAT regression output. You can check your calculation by locating “R²“ in the regression output.

A local electronic company primarily manufactures four highly technical telecommunication products. Each product must be processed in the following departments: component preparation, circuit board fabrication, packaging, and testing. The time requirements in each department (in hours) for each unit produced and its unit profit are summarized in the following table:

Time available per month in each department is 1,500 hours in the Component Preparation department, 2,350 hours in Fabrication, 1,400 hours in Packaging, and 1,200 hours in Testing, respectively. The minimum monthly production requirement for each product to meet the orders received for the coming month is 100 units for A, 300 units for B, and 250 units for D, respectively.

To maximize the profit for the coming month, find the optimal production plan for these four products for the coming month by answering the following questions.

1. Formulate the problem as a spreadsheet model. Color the cells properly. Use range names.
2. Solve the problem using the Solver.
3. Formulate the problem as an algebraic model. Don’t forget to define the decision variables, and express the objective function and all the constraints in terms of the decision variables.
4. How many units are produced for each product in the optimal production plan? What is the total profit?
5. How many hours are used in each department? Is there any department with slack hours? How many hours, if any?
6. What is the shadow price of the Fabrication Department? What does it mean?
7. If 100 more hours are available in the Packaging Department, how much would the total profit increase, if any? Would the optimal solution change?
8. How much can the unit profit of product C decrease before the optimal production plan changes? Explain why.
9. Suppose the unit profit of product A and B each increases by $100, would the optimal production plan change? Why? Explain and show your computation. What is the new total profit after the change?

1. Given the following:

C_(s) + 2H_2(g) → CH_4(g)                         ΔH= −74.6 kJ

C_(s) + 2Cl_2(g) → CCl_4(g)                       ΔH= −95.7 kJ

H_2(g) + Cl_2(g) → 2HCl_(g)                      ΔH= −184.6 kJ

Calculate the enthalpy of reaction for:

CH_4(g) + 4Cl_2(g) → CCl_4(g) + 4HCl_(g)

2. There was a lot of talk among football fans about "deflate-gate" last week (hopefully it's not still going on this week) where the New England Patriots grounds crew seem to have decreased the pressure in the team balls by around 2 PSI from the official value of 12 PSI. (These are Gauge pressures, meaning pressure above 1 atm.) A Physics prof from Boston U. suggested that it may not have been a nefarious plot, but simply a consequence of the fact that it's cold outdoors in Boston and they may have filled the balls indoors. See if this makes sense by calculating the change in pressure (assuming the football had constant volume) between 70 degrees F (nominal inside temperature) and 20 degrees F (a relatively balmy winter-time outside temperature in Boston) from the assumed starting point of 12 PSI.

The Fahrenheit to Celsius conversion is ºC = (ºF – 32)/1.8, there are 14.7 PSI in 1.0 atm, and the volume of a football is 4237 cm³ – though you may not even need that last one.

3.  Imagine you were in the mountains and were desperate for a cup of coffee (or tea, if that's your thing) and the only source of heat you have is a butane cigarette lighter. Could you heat a cup of water at 25 ºC to near boiling with the full capacity of the lighter?

You'll have to make some assumptions about the amount of butane in the lighter and water in your cup, which you should identify; but FYI the density of liquid butane is about 0.6 g/mL, the MW is 58.12 g/mol, and the heat of combustion is -2623 kJ/mol (and of course, the density of water is 1.0 g/mL and the heat capacity is 4.18 J/ºC-g).

4.

You are to write a class named Rectangle. You must use separate files for the header (Rectangle.h) and implementation (Rectangle.cpp) just like you did for the Distance class lab and Deck/Card program. You have been provided the declaration for a class named Point. Assume this class has been implemented. You are just using this class, NOT implementing it. We have also provided a main function that will use the Point and Rectangle classes along with the output of this main function. You must implement your Rectangle class such that this main function will compile and output exactly as in the example given. The Rectangle display represents the 4 corner Points of the Rectangle. You may declare any private data members and declare and implement any private helper functions for the Rectangle class. You may not change or add anything to the Point class.

Exact output needed:
p: (1,1)
r1:
(0,2)(5,2)
(0,0)(5,0)
r2:
(1,5.1)(4.2,5.1)
(1,1)(4.2,1)
r1:
(2,-1)(7,-1)
(2,-3)(7,-3)

Given:
**************************************Main.cpp**************************************

#include "Point.h"
#include "Rectangle.h"
#include <iostream>
using namespace std;

int main() {
Point p = Point(1.0, 1.0);
Point q;
Rectangle r1 = Rectangle(q, Point(5.0, 2.0));
Rectangle r2 = Rectangle(p, 3.2, 4.1);
cout << "p: "; p.display(); cout << endl;
cout << "r1:" << endl;
cout << r1;
cout << "r2:" << endl;
cout << r2;
cout << endl;
r1.move(2.0, -3.0);
cout << "r1:" << endl;
cout << r1;
cout << endl;
return 0;
}

**************************************Point.h**************************************

#ifndef __POINT_H__
#define __POINT_H__
class Point {
private:
double xCoord;
double yCoord;
public:
Point();
Point(double, double);
void display() const; // Display point as (x,y)
double getX() const; // Returns the x coordinate's value
double getY() const; // Returns the y coordinate's value
// Moves the Point dx units along the x axis and dy units along the y axis
void move(double dx, double dy);
};
#endif

********************NEED: Rectangle.h and Rectangle.cpp file

Spiffy Shades Corporation manufactures artistic frames for sunglasses. Talia Demarest, controller, is responsible for preparing the company’s master budget. In compiling the budget data for 20x1, Demarest has learned that new automated production equipment will be installed on March 1. This will reduce the direct labor per frame from 1 hour to 0.75 hour.

Labor-related costs include pension contributions of $0.50 per hour, workers’ compensation insurance of $0.20 per hour, employee medical insurance of $0.80 per hour, and employer contributions to Social Security equal to 7 percent of direct-labor wages. The cost of employee benefits paid by the company on its employees is treated as a direct-labor cost. Spiffy Shades Corporation has a labor contract that calls for a wage increase to $18.00 per hour on April 1, 20x1. Management expects to have 16,000 frames on hand at December 31, 20x0, and has a policy of carrying an end-of-month inventory of 100 percent of the following month’s sales plus 50 percent of the second following month’s sales.

These and other data compiled by Demarest are summarized in the following table.

January February March April May

Direct-labor hours per unit 1.0 1.0 0.75 0.75 0.75

Wage per direct-labor hour $ 16.00 $ 16.00 $ 16.00 $ 18.00 $ 18.00

Estimated unit sales 10,000 12,000 8,000 9,000 9,000

Sales price per unit $ 50.00 $ 47.50 $ 47.50 $ 47.50 $ 47.50

Production overhead: Shipping and handling (per unit sold) $ 2.00 $ 2.00 $ 2.00 $ 2.00 $ 2.00

Purchasing, material handling, and inspection (per unit produced) $ 3.00 $ 3.00 $ 3.00 $ 3.00 $ 3.00

Other production overhead (per direct-labor hour) $ 7.00 $ 7.00 $ 7.00 $ 7.00 $ 7.00

Required: 1. Prepare a production budget and a direct-labor budget for Spiffy Shades Corporation by month and for the first quarter of 20x1. (Round "Direct-labor hours per unit" to 2 decimal places.)

Modify the program 7-5 (pr7-5.cpp) on page 425 by performing the following:

1. Add an overloaded constructor that has a parameter for radius. Negative values should result in radius set to 1.0. (see example 7-6 page 427)

2. Add a member function calcCircumference() to compute and return the circle circumference (2 * 3.14 * radius).

3. In main() "circle1" should be instantiated with a value for radius.

// This program uses a constructor to initialize a member variable.

#include <iostream>

#include <cmath>

using namespace std;

// Circle class declaration

class Circle

{ private:

double radius;

   public: // Member function prototypes

Circle();

void setRadius(double);

double calcArea();

};

// Circle member function implementation section

/********************************************

* Circle::Circle *

* This is the constructor. It initializes *

* the radius class member variable. *

********************************************/

Circle::Circle()

{ radius = 1.0;

}

/********************************************

* Circle::setRadius *

* This function validates the value passed *

* to it before assigning it to the radius *

* member variable. *

********************************************/

void Circle::setRadius(double r)

{ if (r >= 0.0)

radius = r;

// else leave it set to its previous value

}

/**********************************************

* Circle::calcArea *

* This function calculates and returns the *

* Circle object's area. It does not need any *

* parameters because it can directly access *

* the member variable radius. *

**********************************************/

double Circle::calcArea()

{ return 3.14 * pow(radius, 2);

}

/***************************************

* main *

* The main function creates and uses *

* 2 Circle objects. *

***************************************/

int main()

{

// Define a Circle object. Because the setRadius function

// is never called for it, it will keep the value set

// by the constructor.

Circle circle1;

// Define a second Circle object and set its radius to 2.5

Circle circle2;

circle2.setRadius(2.5);

// Get and display each circle's area

cout << "The area of circle1 is " << circle1.calcArea() << endl;

cout << "The area of circle2 is " << circle2.calcArea() << endl;

return 0;

}

4. In main() add two more output statements for showing the circumference of each of the circles (circle1 and circle2).

Example 7-6 on page 427 shows how to overload constructors.

Save and submit your file as pr7-5_Lab.cpp.

Develop a routine to convert Celcius to Fahrenheit. Have a form pass the values and a parm indicating what time of conversion is taking place. Use a function (if possible). Return the correct value.

Here is the formula: C = (F - 32) * 5/9

hw8.html

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title></head>

<body>
<p>Convert Temp</p>
<form id="form1" name="form1" method="get" action="hw8.php">
  <table width="300" border="1">
    <tr>
      <td width="122">Enter Temp </td>
      <td width="168"><label>
        <input name="temp" type="text" id="temp" size="6" maxlength="8" />
      </label></td>
    </tr>
    <tr>
      <td>Convert to &gt;&gt;&gt; </td>
      <td><p>
        <label></label>
        <label>
        <input name="type" type="radio" value="f" checked="checked" />
Fahrenheit</label>
        <br />
        <label>
        <input type="radio" name="type" value="c" />
Celcius</label>
        <br />
        <br />
      </p></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><label>
        <input type="submit" name="Submit" value="Submit" />
      </label></td>
    </tr>
  </table>
</form>
<p><a href="index.htm">return</a></p>
</body>
</html>

hw8.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<p>Temperature Conversion</p>
<p>
  You converted  Fahrenheit to 32 Celcius<br></p>
<p><a href="hw8.html">return</a></p>
</body>
</html>

EDGAR, the Electronic Data Gathering, Analysis, and Retrieval system, performs automated collection, validation, indexing, and forwarding of submissions by companies and others who are required by law to file forms with the U.S. Securities and Exchange Commission (SEC). All publicly traded domestic companies use EDGAR to make the majority of their filings. (Some foreign companies file voluntarily.) Form 10-K, which includes the annual report, is required to be filed on EDGAR. The SEC makes this information available on the Internet.

Required:
1. Access EDGAR on the Internet. The web address is www.sec.gov. Search for the most recent 10-K’s of Expedia, Inc., and Booking Holdings Inc. (which includes Priceline). Search or scroll to find the revenue recognition note in the financial statements.

2. For each of the following types of revenue, indicate whether the amount shown in the income statement is “net” or “gross” (the terms used with respect to revenue recognition in the chapter), and briefly explain your answer.

1. Expedia’s “merchant hotel model” revenues

2. Priceline’s “‘Name Your Own Price’ services”

3. Priceline’s “Merchant Retail Services”

3. Consider your responses to 3a through 3c. Does it look like there is the potential for noncomparability when readers consider Expedia and Priceline? Indicate “yes” or “no,” and briefly explain your answer.