Formulate the problem as a linear programming model use excel and show your excel work. Thank you.

To (cost, in 100's)

Q 38, 42, 44

Comparative advantage implies that a country will

A.

export those goods in which the country has a comparative advantage.

B.

import those goods in which the country has a comparative advantage.

C.

export those goods in which the country has an absolute advantage compared to its trading partner.

D.

import those goods in which the country has an absolute advantage compared to its trading partner.

------------------------------------------------------------------------------------------------------

An income tax​ ________ potential GDP by shifting the labor​ ________ curve​ ________.

A.

​increases; demand; rightward

B.

​increases; supply; rightward

C.

​decreases; demand; leftward

D.

​decreases; supply; leftward

------------------------------------------------------------------------

If the government runs a​ deficit, the total amount of government debt is

A.

increasing.

B.

zero.

C.

constant.

D.

decreasing.

April   107   90   29   31   66   0.344
May   106   94   23   35   72   0.372
June   77   62   12   18   29   0.29
July   115   103   20   34   59   0.33
August   124   102   25   36   63   0.353
September   85   69   20   26   44   0.377

(PYTHON)

Using the attached stats.txt, generate a report of a player’s batting average using hits / at bats by month and slugging percent by dividing total bases by at bats. Print out each month, number hits, number of at bats , BA (batting average) and slugging percent (). The input file is organized by month, plate appearances, at bats, runs, hits and total bases.

A firm has the following information for the last two years. Calculate its degree of financial leverage.

Allegra Inc. has one million shares outstanding. The company is considering the issue of debt of $15 million. The interest rate on this new debt issue will be 8%, and the number of shares after the debt issue will be reduced to 500,000. Given a corporate tax rate of 40%, what is the EBIT that will cause the firm's earnings per share to be indifferent between issuing and not issuing debt?

Doaktown Products manufactures fishing equipment for recreational uses. The Miramichi plant produces the company’s two versions of a special reel used for river fishing. The two models are the M-008, a basic reel, and the M-123, a new and improved version. Cost accountants at company headquarters have prepared costs for the two reels for the most recent period. The plant manager is concerned. The cost report does not coincide with her intuition about the relative costs of the two models. She has asked you to review the cost accounting and help her prepare a response to headquarters.

Manufacturing overhead is currently assigned to products based on their direct labor costs. For the most recent month, manufacturing overhead was $301,600. During that time, the company produced 13,600 units of the M-008 and 2,100 units of the M-123. The direct costs of production were as follows:

Management determined that overhead costs are caused by three cost drivers. These drivers and their costs for last year were as follows:

Navistar International Corporation is an American company that mostly manufactures the big commercial trucks we typically see on the highway. Despite its being an American company, Navistar runs a number of manufacturing plants in Mexico. If a U.S. firm purchases a commercial truck from one of Navistar’s manufacturing plants in Mexico, does that purchase factor into GDP? Why?

The demand and supply for plates in Artist Country have the following characteristics: each buyer will demand at most one plate, and each seller will supply at most one plate. The buyer will demand one plate if the market price is below or equal to his/her reservation price, and the seller will supply one plate if the market price is above or equal to his/her marginal cost. The following table shows the number of buyers at each reservation price and the number of sellers at each marginal cost:

1. Fill in the blanks in the above table and provide brief explanation on how to derive: (i) Quantity demanded and (ii) Quantity supplied in the above table. Brief explanation on how to derive “Quantity demanded. Brief explanation on how to derive “Quantity supplied”.
2. (b) Based on the “Quantity demanded” and “Quantity supplied” derived in part(a), what are the equilibrium price and quantity of plates in this market?
3. Calculate the magnitudes of consumer surplus given the information in the table and the equilibrium derived in part (b). Provide brief explanation on your calculations.
4. Suppose the world price of plates is $4 and Artist Country opens up to free trade. What will be the quantity of plates imported to or exported from Artist Country? (1 mark)
5. Will the social surplus in Artist Country increase or decrease after its opening up to free trade? Who are the winners and losers for Artist Country after free trade? There is no need to include any calculations in your answers.
6. What should the government of Artist Country do if it attempts to protect the losers in part (e) (i.e. consumers or producers of plates that suffer from a reduction in economic surplus)? State two trade intervention policies other than tariff and quota and briefly explain how each of them can serve this purpose.

1). Use the data given below to answer the following questions

i) Evaluate the sample covariance for the height and weight

ii) Find the sample correlation of the two variables.

EZ-Seat, Inc., manufactures two types of reclining chairs, Standard and Ergo. Ergo provides support for the body through a complex set of sensors and requires great care in manufacturing to avoid damage to the material and frame. Standard is a conventional recliner, uses standard materials, and is simpler to manufacture. EZ-Seat’s results for the last fiscal year are shown in the following statement.

EZ-Seat currently uses labor costs to allocate all overhead, but management is considering implementing an activity-based costing system. After interviewing the sales and production staff, management decides to allocate administrative costs on the basis of direct labor costs but to use the following bases to allocate the remaining costs.

Required:

a. Complete the income statement using the preceding activity bases.

c. Restate the income statement for EZ-Seat using direct labor costs as the only overhead allocation base.

Problem 9-17

Each unit of A is composed of one unit of B, two units of C, and one unit of D. C is composed of two units of D and three units of E. Items A, C, D, and E have on-hand inventories of 25, 20, 40, and 40 units, respectively. Item B has a scheduled receipt of 15 units in Period 1, and C has a scheduled receipt of 50 units in Period 1. Lot-for-lot (L4L) is used for Items A and B. Item C requires a minimum lot size of 60 units. D and E are required to be purchased in multiples of 110 and 60, respectively. Lead times are one period for Items A, B, and C, and two periods for Items D and E. The gross requirements for A are 40 in Period 2, 30 in Period 5, and 45 in Period 8.

Find the planned order releases for all items. (Leave no cells blank - be certain to enter "0" wherever required.)