A community hospital is planning to expand its services to three new service lines in the medical diagnostic categories (MDC-2, MDC-19, and MDC-21). Five common resources must be allocated among these three new service lines according to which will bring the most revenue. The resources are LOS, nursing hours, radiology procedures, laboratory procedures, and operating rooms. The health care manager in charge of this expansion project obtained the average consumption patterns of these resources for each MDC from other peer institutions, and estimated the resources that can be made available (per year) for the new service lines as listed below. Based on the available information the average revenues from MDC - 2, MDC - 19, and MDC - 21 are $8,885, $ 10,143, and $12,711, respectively.

1. What are the decision variables?
2. What are constrains on manager's decision?
3. What is the Objective Function?
4. Using Excel Solver to solve the problem and answer the following questions:

1. Which service(s) should be offered to get the most revenue?

1. What are the optimal volumes for the service(s) to be offered?

1. What is the total expected revenue from the new services?

1. Looking at the Sensitivity report for Solver results, answer the following questions:

1.) Which resources should be expanded and,

2.) How much additional revenue can be expected if resources are selected for expansion without violating the current solution?

I need this question answered assuming that Westgate Construction's contract with Santa Clara County does NOT qualify for revenue recongnition over time... In 2016, the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,000. The road was completed in 2018. Information related to the contract is as follows:

Tacoma Hospital has three support departments and four patient services departments. The direct costs to each of the support departments are as follows:

Tacoma Hospital has three support departments and four patient services departments. The direct costs to each of the support departments are as follows:

The patient services revenue, salary dollars, and housekeeping labor hours for each department are as follows:

Assume that the hospital uses the step-down method for cost allocation (see pages 230 0 232), with salary dollars as the cost driver for general administration, housekeeping labor hours as the cost driver for facilities, and patient services revenue as the cost driver for financial services. Assume also that the general administration department provides the most services to other support departments, followed closely by the facilities department. The financial services department provides the least services to the other support departments.

a. Use an allocation table to allocate the hospital’s overhead costs to the patient services departments.

b. Is the direct method or the step-down method better for cost allocation within Tacoma Hospital’s? Please explain.

Forecast Sales Volume and Sales Budget

For 20Y8, Raphael Frame Company prepared the sales budget that follows.

At the end of December 20Y8, the following unit sales data were reported for the year:

For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending December 31, 20Y8. The unit selling price for the 8" × 10" frame is expected to increase to $28 and the unit selling price for the 12" × 16" frame is expected to increase to $30, effective January 1, 20Y9.

Required:

1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y8, over budget. Use the minus sign to indicate a decrease in amount and percent. Round percents to the nearest whole percent.

2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y9. Use the minus sign to indicate a decrease in percent. Round budgeted units to the nearest whole unit.

3.  Prepare a sales budget for the year ending December 31, 20Y9.

Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Calvin Motorsports, Inc., owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways. Current Year Previous Year Revenues: Admissions $94,400 $107,580 Event-related revenue 138,768 147,189 NASCAR broadcasting revenue 169,448 160,881 Other operating revenue 69,384 73,350 Total revenue $472,000 $489,000 Expenses and other: Direct expense of events $93,928 $94,377 NASCAR purse and sanction fees 118,000 126,162 Other direct expenses 27,848 23,961 General and administrative 178,416 218,583 Total expenses and other $418,192 $463,083 Income from continuing operations $53,808 $25,917 a. Prepare a comparative income statement for these two years in vertical form, stating each item as a percent of revenues. Round to one decimal place. Enter all amounts as positive numbers. Calvin Motorsports, Inc. Comparative Income Statement (in thousands of dollars) For the Years Ended December 31 Current Year Amount Current Year Percent Prior Year Amount Prior Year Percent Revenues: Admissions $94,400 % $107,580 % Event-related revenue 138,768 % 147,189 % NASCAR broadcasting revenue 169,448 % 160,881 % Other operating revenue 69,384 % 73,350 % Total revenue $472,000 % $489,000 % Expenses and other: Direct expense of events $93,928 % $94,377 % NASCAR purse and sanction fees 118,000 % 126,162 % Other direct expenses 27,848 % 23,961 % General and administrative 178,416 % 218,583 % Total expenses and other $418,192 % $463,083 % Income from continuing operations $53,808 % $25,917 % b. While overall revenue some between the two years, the overall mix of revenue sources did change somewhat. The NASCAR broadcasting revenue as a percent of total revenue by 3 percentage points, while the percent of admissions revenue to total revenue by 2 percentage points. Overall, it appears that income from continuing operations has significantly improved because of .

Vertical Analysis of Income Statement

The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Calvin Motorsports, Inc., owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways.

a. Prepare a comparative income statement for these two years in vertical form, stating each item as a percent of revenues. Round to one decimal place. Enter all amounts as positive numbers.

b. While overall revenue   some between the two years, the overall mix of revenue sources did change somewhat. The NASCAR broadcasting revenue   as a percent of total revenue by 3 percentage points, while the percent of admissions revenue to total revenue   by 2 percentage points. Overall, it appears that income from continuing operations has significantly improved because of  .

Question 2

In a normal distribution, approximately __________ percent of the distribution falls between one standard deviation below the mean and one standard deviation above the mean

Question 3

In a normal distribution, approximately __________ percent of the distribution falls between two standard deviations below the mean and two standard deviations above the mean.

Question 4

In a normal distribution, approximately __________ percent of the distribution falls between three standard deviations below the mean and three standard deviations above the mean.