Tag: Accounting

[Solved] do test only use techniqes found in files

✓ Verified Academic Solution Available

Executive Solution Overview

will probably not use all files – ## LPprojectselectionandtransportationaug271.xlsx – ## LPprojectselectionandtransportationaug27.xlsx – ## transportationsept10.xlsx – ## LPbasicwordproblemaug20.xlsx – Decisiontheory1QUAN4630sept24.xlsx – LPbasicaug13.xlsx – Utilityoct8.xlsx – SKM_C300i25100117370….

Instant Solution Download
$6.99

Immediate access to the full model answer, formatted citations, and rubric breakdown.

Need a Fresh Custom Paper?

Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →

Assignment Prompt & Instructions

will probably not use all files

– ## LPprojectselectionandtransportationaug271.xlsx

– ## LPprojectselectionandtransportationaug27.xlsx

– ## transportationsept10.xlsx

– ## LPbasicwordproblemaug20.xlsx

– Decisiontheory1QUAN4630sept24.xlsx
– LPbasicaug13.xlsx
– Utilityoct8.xlsx
– SKM_C300i25100117370.pdf
– CuttingLPrevisedaug20.xlsx
– ClassificationwithDiscriminantAnalysisOct29.xlsx
– ForecastingQUAN4630nov12.xlsx
– CollegesandUniversitiesClusterAnalysisWorksheetNov5.xlsx
– QUAN4630takehomeFA25.xlsx
– RegressionQUAN4640oct15.xlsx

**## LPprojectselectionandtransportationaug271.xlsx**

## project selection

| | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — |
| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Available |
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 |
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | 12 |

| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 |
| | 1 | 0 | 1 | 0 | 1 |

| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 | | total expected $ return | $ 530,000.00 | <= | Available |

| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | | total cash spent | $ 140,000.00 | | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | | total number of empl | 10 | | 12 |

We are charged with selecting from the five projects (shown at left). We do not have enough cash or employees to select all of them, so we will have to select a subset.

Our goal is to maximize the expected dollar return while keeping within our available resources (cash and employees).

## transportation

| | | | | | |
| — | — | — | — | — | — |
| | | DISTRIBUTION | CENTER |
| PLANT | Cleveland | Baltimore | Chicago | Phoenix | Capacity |
| Marietta | $ 12.60 | $ 14.35 | $ 11.52 | $ 17.58 | 1200 |
| Minneapolis | $ 9.75 | $ 16.26 | $ 8.11 | $ 17.92 | 800 |
| Demand | 150 | 350 | 500 | 1000 |

Suppose we need to ship refrigerators from our plants in Marietta and Minneapolis to our distribution centers in Cleveland, Baltimore, Chicago, and Phoenix.

Capacities, demand, and unit shipping costs are shown in the table. Our goal is to meet demand at the lowest total shipping cost.

**## LPprojectselectionandtransportationaug27.xlsx**

## project selection

| | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — |
| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Available |
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 |
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | 12 |

| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 |
| | 1 | 0 | 1 | 0 | 1 |

| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 | | total expected $ return | $ 530,000.00 | <= | Available |

| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | | total cash spent | $ 140,000.00 | | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | | total number of empl | 10 | | 12 |

We are charged with selecting from the five projects (shown at left). We do not have enough cash or employees to select all of them, so we will have to select a subset.

Our goal is to maximize the expected dollar return while keeping within our available resources (cash and employees).

## transportation

| | | | | | |
| — | — | — | — | — | — |
| | | DISTRIBUTION | CENTER |
| PLANT | Cleveland | Baltimore | Chicago | Phoenix | Capacity |
| Marietta | $ 12.60 | $ 14.35 | $ 11.52 | $ 17.58 | 1200 |
| Minneapolis | $ 9.75 | $ 16.26 | $ 8.11 | $ 17.92 | 800 |
| Demand | 150 | 350 | 500 | 1000 |

Suppose we need to ship refrigerators from our plants in Marietta and Minneapolis to our distribution centers in Cleveland, Baltimore, Chicago, and Phoenix.

Capacities, demand, and unit shipping costs are shown in the table. Our goal is to meet demand at the lowest total shipping cost.

**## transportationsept10.xlsx**

## project selection

| | | | | | | |
| — | — | — | — | — | — | — |
| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Available |
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 |
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | 12 |

We are charged with selecting from the five projects (shown at left). We do not have enough cash or employees to select all of them, so we will have to select a subset.

Our goal is to maximize the expected dollar return while keeping within our available resources (cash and employees).

## transportation

| | | | | | |
| — | — | — | — | — | — |
| | | DISTRIBUTION | CENTER |
| PLANT | Cleveland | Baltimore | Chicago | Phoenix | Capacity |
| Marietta | $ 12.60 | $ 14.35 | $ 11.52 | $ 17.58 | 1200 |
| Minneapolis | $ 9.75 | $ 16.26 | $ 8.11 | $ 17.92 | 800 |
| Demand | 150 | 350 | 500 | 1000 |
| | | DISTRIBUTION | CENTER |
| PLANT | Cleveland | Baltimore | Chicago | Phoenix |
| Marietta | 0 | 350 | 0 | 850 | integers |
| Minneapolis | 150 | 0 | 500 | 150 |
| min total ship cost | $ 28,171.00 |

| constraints | | total shipped | <= | capacity |
| Marietta shipping | | 1200 | | 1200 |
| Minn shipping | | 800 | | 800 |
| | | total received | >= | demand |
| Cleveland receiving | | 150 | | 150 |
| Baltimore receiving | | 350 | | 350 |
| Chicago receiving | | 500 | | 500 |
| Phoenix receiving | | 1000 | | 1000 |

Suppose we need to ship refrigerators from our plants in Marietta and Minneapolis to our distribution centers in Cleveland, Baltimore, Chicago, and Phoenix.

Capacities, demand, and unit shipping costs are shown in the table. Our goal is to meet demand at the lowest total shipping cost.

**## LPbasicwordproblemaug20.xlsx**

## Basic LP

|
|

Maximize 5A -3B +10C

subject to:

A + B + 3C <= 20

B >= 2

3A – 2B <= 15

A,B,C >= 0

## Sheds

| | | | | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| | | | | | | | type A | type B | type C |
| | | | | | | | 2 | 0 | 49 |
| | | | | | | profit | 80 | 84 | 85 | max | $ 4,325.00 |

| | | | | | | mach time | 2 | 3 | 4 | | 200 | <= | 200 |
| | | | | | | craft time | 5 | 5 | 3 | | 157 | <= | 160 |

A small firm builds three types of garden sheds.
Type A requires 2 hours of machine time and 5 hours of craftsman time.

Type B requires 3 hours of machine time and 5 hours of craftsman time.

Type C requires 4 hours of machine time and 3 hours of craftsman time.

Each day there are 200 hours of machine time available and 160 hours of craftsman time.

The profit on each type A shed is $80, on each type B shed is $84, and on each type C shed is 85 .

How many sheds of each type should we make to maximize the profit?

**Decisiontheory1QUAN4630sept24.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/decisiontheory1quan4630sept24-xlsx-10462391)

**LPbasicaug13.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/lpbasicaug13-xlsx-10462367)

**Utilityoct8.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/utilityoct8-xlsx-10462379)

**SKM_C300i25100117370.pdf**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/skm-c300i25100117370-pdf-10462393)

**CuttingLPrevisedaug20.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/cuttinglprevisedaug20-xlsx-10462369)

**ClassificationwithDiscriminantAnalysisOct29.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/classificationwithdiscriminantanalysisoct29-xlsx-10462389)

**ForecastingQUAN4630nov12.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/forecastingquan4630nov12-xlsx-10462387)

**CollegesandUniversitiesClusterAnalysisWorksheetNov5.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/collegesanduniversitiesclusteranalysisworksheetnov5-xlsx-10462383)

**QUAN4630takehomeFA25.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/quan4630takehomefa25-xlsx-10462385)

**RegressionQUAN4640oct15.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/regressionquan4640oct15-xlsx-10462377)

**RegressionQUAN4640oct15.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/regressionquan4640oct15-xlsx-10462377)

**## LPprojectselectionandtransportationaug271.xlsx**

## project selection

| | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — |
| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Available |
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 |
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | 12 |

| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 |
| | 1 | 0 | 1 | 0 | 1 |

| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 | | total expected $ return | $ 530,000.00 | <= | Available |

| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | | total cash spent | $ 140,000.00 | | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | | total number of empl | 10 | | 12 |

We are charged with selecting from the five projects (shown at left). We do not have enough cash or employees to select all of them, so we will have to select a subset.

Our goal is to maximize the expected dollar return while keeping within our available resources (cash and employees).

## transportation

| | | | | | |
| — | — | — | — | — | — |
| | | DISTRIBUTION | CENTER |
| PLANT | Cleveland | Baltimore | Chicago | Phoenix | Capacity |
| Marietta | $ 12.60 | $ 14.35 | $ 11.52 | $ 17.58 | 1200 |
| Minneapolis | $ 9.75 | $ 16.26 | $ 8.11 | $ 17.92 | 800 |
| Demand | 150 | 350 | 500 | 1000 |

Suppose we need to ship refrigerators from our plants in Marietta and Minneapolis to our distribution centers in Cleveland, Baltimore, Chicago, and Phoenix.

Capacities, demand, and unit shipping costs are shown in the table. Our goal is to meet demand at the lowest total shipping cost.

**## LPprojectselectionandtransportationaug27.xlsx**

## project selection

| | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — |
| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Available |
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 |
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | 12 |

| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 |
| | 1 | 0 | 1 | 0 | 1 |

| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 | | total expected $ return | $ 530,000.00 | <= | Available |

| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | | total cash spent | $ 140,000.00 | | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | | total number of empl | 10 | | 12 |

We are charged with selecting from the five projects (shown at left). We do not have enough cash or employees to select all of them, so we will have to select a subset.

Our goal is to maximize the expected dollar return while keeping within our available resources (cash and employees).

## transportation

| | | | | | |
| — | — | — | — | — | — |
| | | DISTRIBUTION | CENTER |
| PLANT | Cleveland | Baltimore | Chicago | Phoenix | Capacity |
| Marietta | $ 12.60 | $ 14.35 | $ 11.52 | $ 17.58 | 1200 |
| Minneapolis | $ 9.75 | $ 16.26 | $ 8.11 | $ 17.92 | 800 |
| Demand | 150 | 350 | 500 | 1000 |

Suppose we need to ship refrigerators from our plants in Marietta and Minneapolis to our distribution centers in Cleveland, Baltimore, Chicago, and Phoenix.

Capacities, demand, and unit shipping costs are shown in the table. Our goal is to meet demand at the lowest total shipping cost.

**## transportationsept10.xlsx**

## project selection

| | | | | | | |
| — | — | — | — | — | — | — |
| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Available |
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 |
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | 12 |

We are charged with selecting from the five projects (shown at left). We do not have enough cash or employees to select all of them, so we will have to select a subset.

Our goal is to maximize the expected dollar return while keeping within our available resources (cash and employees).

## transportation

| | | | | | |
| — | — | — | — | — | — |
| | | DISTRIBUTION | CENTER |
| PLANT | Cleveland | Baltimore | Chicago | Phoenix | Capacity |
| Marietta | $ 12.60 | $ 14.35 | $ 11.52 | $ 17.58 | 1200 |
| Minneapolis | $ 9.75 | $ 16.26 | $ 8.11 | $ 17.92 | 800 |
| Demand | 150 | 350 | 500 | 1000 |
| | | DISTRIBUTION | CENTER |
| PLANT | Cleveland | Baltimore | Chicago | Phoenix |
| Marietta | 0 | 350 | 0 | 850 | integers |
| Minneapolis | 150 | 0 | 500 | 150 |
| min total ship cost | $ 28,171.00 |

| constraints | | total shipped | <= | capacity |
| Marietta shipping | | 1200 | | 1200 |
| Minn shipping | | 800 | | 800 |
| | | total received | >= | demand |
| Cleveland receiving | | 150 | | 150 |
| Baltimore receiving | | 350 | | 350 |
| Chicago receiving | | 500 | | 500 |
| Phoenix receiving | | 1000 | | 1000 |

Suppose we need to ship refrigerators from our plants in Marietta and Minneapolis to our distribution centers in Cleveland, Baltimore, Chicago, and Phoenix.

Capacities, demand, and unit shipping costs are shown in the table. Our goal is to meet demand at the lowest total shipping cost.

**## LPbasicwordproblemaug20.xlsx**

## Basic LP

|
|

Maximize 5A -3B +10C

subject to:

A + B + 3C <= 20

B >= 2

3A – 2B <= 15

A,B,C >= 0

## Sheds

| | | | | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| | | | | | | | type A | type B | type C |
| | | | | | | | 2 | 0 | 49 |
| | | | | | | profit | 80 | 84 | 85 | max | $ 4,325.00 |

| | | | | | | mach time | 2 | 3 | 4 | | 200 | <= | 200 |
| | | | | | | craft time | 5 | 5 | 3 | | 157 | <= | 160 |

A small firm builds three types of garden sheds.
Type A requires 2 hours of machine time and 5 hours of craftsman time.

Type B requires 3 hours of machine time and 5 hours of craftsman time.

Type C requires 4 hours of machine time and 3 hours of craftsman time.

Each day there are 200 hours of machine time available and 160 hours of craftsman time.

The profit on each type A shed is $80, on each type B shed is $84, and on each type C shed is 85 .

How many sheds of each type should we make to maximize the profit?

**Decisiontheory1QUAN4630sept24.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/decisiontheory1quan4630sept24-xlsx-10462391)

**LPbasicaug13.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/lpbasicaug13-xlsx-10462367)

**Utilityoct8.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/utilityoct8-xlsx-10462379)

**SKM_C300i25100117370.pdf**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/skm-c300i25100117370-pdf-10462393)

**CuttingLPrevisedaug20.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/cuttinglprevisedaug20-xlsx-10462369)

**ClassificationwithDiscriminantAnalysisOct29.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/classificationwithdiscriminantanalysisoct29-xlsx-10462389)

**ForecastingQUAN4630nov12.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/forecastingquan4630nov12-xlsx-10462387)

**CollegesandUniversitiesClusterAnalysisWorksheetNov5.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/collegesanduniversitiesclusteranalysisworksheetnov5-xlsx-10462383)

**QUAN4630takehomeFA25.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/quan4630takehomefa25-xlsx-10462385)

**RegressionQUAN4640oct15.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/regressionquan4640oct15-xlsx-10462377)

**## LPprojectselectionandtransportationaug271.xlsx**

## project selection

| | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — |
| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Available |
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 |
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | 12 |

| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 |
| | 1 | 0 | 1 | 0 | 1 |

| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 | | total expected $ return | $ 530,000.00 | <= | Available |

| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | | total cash spent | $ 140,000.00 | | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | | total number of empl | 10 | | 12 |

We are charged with selecting from the five projects (shown at left). We do not have enough cash or employees to select all of them, so we will have to select a subset.

Our goal is to maximize the expected dollar return while keeping within our available resources (cash and employees).

## transportation

| | | | | | |
| — | — | — | — | — | — |
| | | DISTRIBUTION | CENTER |
| PLANT | Cleveland | Baltimore | Chicago | Phoenix | Capacity |
| Marietta | $ 12.60 | $ 14.35 | $ 11.52 | $ 17.58 | 1200 |
| Minneapolis | $ 9.75 | $ 16.26 | $ 8.11 | $ 17.92 | 800 |
| Demand | 150 | 350 | 500 | 1000 |

Suppose we need to ship refrigerators from our plants in Marietta and Minneapolis to our distribution centers in Cleveland, Baltimore, Chicago, and Phoenix.

Capacities, demand, and unit shipping costs are shown in the table. Our goal is to meet demand at the lowest total shipping cost.

**## LPprojectselectionandtransportationaug27.xlsx**

## project selection

| | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — |
| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Available |
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 |
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | 12 |

| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 |
| | 1 | 0 | 1 | 0 | 1 |

| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 | | total expected $ return | $ 530,000.00 | <= | Available |

| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | | total cash spent | $ 140,000.00 | | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | | total number of empl | 10 | | 12 |

We are charged with selecting from the five projects (shown at left). We do not have enough cash or employees to select all of them, so we will have to select a subset.

Our goal is to maximize the expected dollar return while keeping within our available resources (cash and employees).

## transportation

| | | | | | |
| — | — | — | — | — | — |
| | | DISTRIBUTION | CENTER |
| PLANT | Cleveland | Baltimore | Chicago | Phoenix | Capacity |
| Marietta | $ 12.60 | $ 14.35 | $ 11.52 | $ 17.58 | 1200 |
| Minneapolis | $ 9.75 | $ 16.26 | $ 8.11 | $ 17.92 | 800 |
| Demand | 150 | 350 | 500 | 1000 |

Suppose we need to ship refrigerators from our plants in Marietta and Minneapolis to our distribution centers in Cleveland, Baltimore, Chicago, and Phoenix.

Capacities, demand, and unit shipping costs are shown in the table. Our goal is to meet demand at the lowest total shipping cost.

**## transportationsept10.xlsx**

## project selection

| | | | | | | |
| — | — | — | — | — | — | — |
| | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Available |
| Expected dollar return | $ 180,000.00 | $ 220,000.00 | $ 150,000.00 | $ 140,000.00 | $ 200,000.00 |
| Cash needed | $ 55,000.00 | $ 83,000.00 | $ 24,000.00 | $ 49,000.00 | $ 61,000.00 | $ 150,000.00 |
| No. of employees | 5 | 3 | 2 | 5 | 3 | 12 |

We are charged with selecting from the five projects (shown at left). We do not have enough cash or employees to select all of them, so we will have to select a subset.

Our goal is to maximize the expected dollar return while keeping within our available resources (cash and employees).

## transportation

| | | | | | |
| — | — | — | — | — | — |
| | | DISTRIBUTION | CENTER |
| PLANT | Cleveland | Baltimore | Chicago | Phoenix | Capacity |
| Marietta | $ 12.60 | $ 14.35 | $ 11.52 | $ 17.58 | 1200 |
| Minneapolis | $ 9.75 | $ 16.26 | $ 8.11 | $ 17.92 | 800 |
| Demand | 150 | 350 | 500 | 1000 |
| | | DISTRIBUTION | CENTER |
| PLANT | Cleveland | Baltimore | Chicago | Phoenix |
| Marietta | 0 | 350 | 0 | 850 | integers |
| Minneapolis | 150 | 0 | 500 | 150 |
| min total ship cost | $ 28,171.00 |

| constraints | | total shipped | <= | capacity |
| Marietta shipping | | 1200 | | 1200 |
| Minn shipping | | 800 | | 800 |
| | | total received | >= | demand |
| Cleveland receiving | | 150 | | 150 |
| Baltimore receiving | | 350 | | 350 |
| Chicago receiving | | 500 | | 500 |
| Phoenix receiving | | 1000 | | 1000 |

Suppose we need to ship refrigerators from our plants in Marietta and Minneapolis to our distribution centers in Cleveland, Baltimore, Chicago, and Phoenix.

Capacities, demand, and unit shipping costs are shown in the table. Our goal is to meet demand at the lowest total shipping cost.

**## LPbasicwordproblemaug20.xlsx**

## Basic LP

|
|

Maximize 5A -3B +10C

subject to:

A + B + 3C <= 20

B >= 2

3A – 2B <= 15

A,B,C >= 0

## Sheds

| | | | | | | | | | | | | | |
| — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| | | | | | | | type A | type B | type C |
| | | | | | | | 2 | 0 | 49 |
| | | | | | | profit | 80 | 84 | 85 | max | $ 4,325.00 |

| | | | | | | mach time | 2 | 3 | 4 | | 200 | <= | 200 |
| | | | | | | craft time | 5 | 5 | 3 | | 157 | <= | 160 |

A small firm builds three types of garden sheds.
Type A requires 2 hours of machine time and 5 hours of craftsman time.

Type B requires 3 hours of machine time and 5 hours of craftsman time.

Type C requires 4 hours of machine time and 3 hours of craftsman time.

Each day there are 200 hours of machine time available and 160 hours of craftsman time.

The profit on each type A shed is $80, on each type B shed is $84, and on each type C shed is 85 .

How many sheds of each type should we make to maximize the profit?

**Decisiontheory1QUAN4630sept24.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/decisiontheory1quan4630sept24-xlsx-10462391)

**LPbasicaug13.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/lpbasicaug13-xlsx-10462367)

**Utilityoct8.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/utilityoct8-xlsx-10462379)

**SKM_C300i25100117370.pdf**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/skm-c300i25100117370-pdf-10462393)

**CuttingLPrevisedaug20.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/cuttinglprevisedaug20-xlsx-10462369)

**ClassificationwithDiscriminantAnalysisOct29.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/classificationwithdiscriminantanalysisoct29-xlsx-10462389)

**ForecastingQUAN4630nov12.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/forecastingquan4630nov12-xlsx-10462387)

**CollegesandUniversitiesClusterAnalysisWorksheetNov5.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/collegesanduniversitiesclusteranalysisworksheetnov5-xlsx-10462383)

**QUAN4630takehomeFA25.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/quan4630takehomefa25-xlsx-10462385)

**RegressionQUAN4640oct15.xlsx**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/regressionquan4640oct15-xlsx-10462377)

– 1
– 2
– 3
– 4
– 5
– 6
– 7
– 8
– 9
– 10
– 11
– 12
– 13
– 14

November 5, 2026
[Solved] Business Project

✓ Verified Academic Solution Available

Executive Solution Overview

**PROJECT INFORMATION:** You are considering opening a retail establishment, ABC Company, and need to make a number of decisions regarding this new company and prepare a number of documents. **Course objectives covered:** 1, 2, 4, 5, 6 Wild, J. J., & Shaw, K. W. (2025). Fundamental accounting princi…

Instant Solution Download
$6.99

Immediate access to the full model answer, formatted citations, and rubric breakdown.

Need a Fresh Custom Paper?

Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →

Assignment Prompt & Instructions

**PROJECT INFORMATION:**
You are considering opening a retail establishment, ABC Company, and need to make a number of decisions regarding this new company and prepare a number of documents.
**Course objectives covered:** 1, 2, 4, 5, 6
Wild, J. J., & Shaw, K. W. (2025). Fundamental accounting principles (25th ed.). McGraw-Hill
**PROJECT REQUIREMENTS:**
This project is split into four (4) parts, with one (1) part due each week of the course.
Parts 1, 2, and 3 will utilize Microsoft Excel and Microsoft Word. Part 4 is your Voice-Over PowerPoint to be submitted in the Week 4 Presentation Discussion Board.

November 5, 2026
[Solved] Benchmark – Budgeting and Planning

✓ Verified Academic Solution Available

Executive Solution Overview

_**Part 1: Addressing the Key Questions From the Case**_ Read Case 9-26 "Performance Report With More Than One Cost Driver," located in Chapter 9 of the textbook. Use Exhibit 9-11 as a model. Consider the characteristics of a flexible budget and how it might minimize the deficiencies of the master (…

Instant Solution Download
$6.99

Immediate access to the full model answer, formatted citations, and rubric breakdown.

Need a Fresh Custom Paper?

Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →

Assignment Prompt & Instructions

_**Part 1: Addressing the Key Questions From the Case**_
Read Case 9-26 "Performance Report With More Than One Cost Driver," located in Chapter 9 of the textbook. Use Exhibit 9-11 as a model. Consider the characteristics of a flexible budget and how it might minimize the deficiencies of the master (static) budget.
1. Using Exhibit 9-11 as your guide, prepare a flexible budget performance report for the year that shows both spending variances and activity variances.
2. If you were on the board of directors of the theater, would you be pleased with how well costs were controlled during the year? Why, or why not?
3. The cost formulas provide figures for the average cost per production and average cost per performance. How accurate do you think these figures would be for predicting the cost of a new production or of an additional performance of a particular production?
_**Part 2: Reflecting on the Case**_
Reflect on what you learned in Part 1 and respond to the following questions.
1. Describe how the budgeting and accounting processes within an organization support ethical financial planning and decision-making.
2. When reporting financial data, what steps do you take to demonstrate ethical behavior to ensure the integrity of data collection, analysis, and reporting?
3. Include a Biblical principle related to budgeting or ethical decision-making to foster dignity and promote moral values.
_**General Requirements**_
Include at least two scholarly sources in addition to your textbook.

November 5, 2026
[Solved] 163

✓ Verified Academic Solution Available

Executive Solution Overview

In-depth study guidance and analytical solution covering 163.

Instant Solution Download
$6.99

Immediate access to the full model answer, formatted citations, and rubric breakdown.

Need a Fresh Custom Paper?

Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →

Assignment Prompt & Instructions

Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

November 5, 2026
[Solved] class 2

✓ Verified Academic Solution Available

Executive Solution Overview

In-depth study guidance and analytical solution covering class 2.

Instant Solution Download
$6.99

Immediate access to the full model answer, formatted citations, and rubric breakdown.

Need a Fresh Custom Paper?

Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →

Assignment Prompt & Instructions

Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

November 5, 2026
[Solved] major project due 1 dec

✓ Verified Academic Solution Available

Executive Solution Overview

– Click on this link to download the [workbook (Links to an external site.)Links to an external site.](https://public.tableau.com/app/profile/marleen.meier/viz/MasteringTableau3_0%C2%A0) that accompanies your textbook. – Download the Chapter 5 Starter Workbook. Save the file. – Start with the Fundam…

Instant Solution Download
$6.99

Immediate access to the full model answer, formatted citations, and rubric breakdown.

Need a Fresh Custom Paper?

Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →

Assignment Prompt & Instructions

– Click on this link to download the [workbook (Links to an external site.)Links to an external site.](https://public.tableau.com/app/profile/marleen.meier/viz/MasteringTableau3_0%C2%A0) that accompanies your textbook.
– Download the Chapter 5 Starter Workbook. Save the file.
– Start with the Fundamentals of Visualizations workbook.
– Follow along in Chapter 7, starting on page 3.
– Return to the [Workbook Download Site (Links to an external site.)Links to an external site.](https://public.tableau.com/app/profile/marleen.meier/viz/MasteringTableau3_0)
– Download the Chapter 2 Starter Workbook. Save the file.
– Follow along in Chapter 2, starting on page 62.
– Continue with the directions in the book.
– When you are finished with your workbooks, make sure you publish them to share with your professor.

November 5, 2026
[Solved] Business Finance – Accounting Final Writing Assignment Private Letter Ruling

✓ Verified Academic Solution Available

Executive Solution Overview

You represent “Ilicita Construction Co.” (“Client”) a Construction company with close to thirty (30) years of operating history. It was formed in Homestead, Florida in 1998 and builds medium to large residential and commercial buildings. The company started out with very limited earnings but now has…

Instant Solution Download
$6.99

Immediate access to the full model answer, formatted citations, and rubric breakdown.

Need a Fresh Custom Paper?

Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →

Assignment Prompt & Instructions

You represent “Ilicita Construction Co.” (“Client”) a Construction company with close to thirty (30) years of operating history. It was formed in Homestead, Florida in 1998 and builds medium to large residential and commercial buildings. The company started out with very limited earnings but now has a top line of $100,000,000. It has six (6) shareholders who are members of the same family, three brothers and three sisters. The Company has been filing S corporation returns Form 1120S since it’s first Form 1120S in 1999 for TYE 1998. The Company was formed as a corporation in the State of Florida on June 30, 1998 according to Sunbiz.org and the original corporate filings there.
The Company was selected for a random Audit by the IRS in the summer of 2025. The IRS agent set an information request which included a request for the original S Corporation determination letter and the originally filed Form 2553, signed by all of the shareholders.
As the CPA, with primary authority for the engagement, you ask the Vice-President of the Client to check for the records in the Company’s corporate book or elsewhere for copies of the requested information. In addition, you send request letters to the Client’s prior Law Firm and CPA firm.
The Corporate book, unfortunately is not well documented. Your review of the book indicates that there are no minutes and shares have never been properly issued or just aren’t present in the corporate book. The transfer records have not been filled out. Copies of the SS-4 and 2553 if any are not in the corporate book. None of the Corporate officers recalls or knows where these records are or if they were originally issued.
Each of the shareholders insists that they signed and filed the Form 2553 shortly after formation. but no shareholder or prior accountant had a copy of the original s Corp filing or the approval letter from the IRS.  The IRS has no record of a 2553 being filed, but they did have the information on the SS-4 filed in 1998 that expressed a desire to be treated as an S corporation. Further, Construction co has filed an S corporation return for each year of its existence starting in 1999 and each shareholder has provided their ratable share of tax attributes on Schedule E of their returns and has included the income and paid tax on the amounts so reported,
The two oldest male shareholders recently completed some estate planning transactions and each created one or more irrevocable trusts for which an ESBT election was required and made. It is thought that the filing of the ESBT election may have triggered the audit. That is unclear.
In any event, you see that one of the trusts, should have field a QSST rather than an ESBT Election. You need to advise the Client that you need to change that.
As a result of the foregoing history, you are asked to request a private letter ruling in accordance with Revenue Procedure 2013-30 – Relief for Late S Corporation Election. Requesting that the IRS retroactively approve S corporation status for the entity.
Please also pull IRM 21.7.4.4.4.11.2.1
You begin to get slightly nervous about the ruling request and Pull the appropriate Ruling request information available on Rev. Proc. 2025-1.   I provided this to you in Modules and Teams
1. Your first task is to draft the facts you will believe are required to support a positive response from the IRS on your ruling request.
_**Draft a Client letter requesting the facts from the Client**_. The facts you need are those that the Rev Proc. IRM and general S corporation filings require. Start by accessing at least two AI sources and CCH answer Connect from the library and looking up Relief for Late S corporation elections.
Use at least two AI sources to give you any help with drafting a client letter. Choose the one that in your opinion is the best source and modify the letter into a format that “you” believe expresses how you would want to communicate the requests and potential solution to your client.
1. Your second task is to Convert the ESBT Election to a QSST election see Treas. Reg. §1.1361-1(m) for one of the Trusts. Look this up on your preferred AI and on CCH Answer Connect. It should give you support information.
2. Using Rev. Proc. 2025-1 and AI of your choosing as a guide, create the template for the Private Letter Ruling you will write including the required attachments.
\
Rev.Proc.2025-1.docx](https://www.sweetstudy.com/files/rev-proc-2025-1-docx "Rev.Proc.2025-1.docx")
\
TaxLawyerStyleManual.pdf](https://www.sweetstudy.com/files/taxlawyerstylemanual-pdf "TaxLawyerStyleManual.pdf")
\
RelieveforLateESBTElections.pdf](https://www.sweetstudy.com/files/relieveforlateesbtelections-pdf "RelieveforLateESBTElections.pdf")
\
USTC_Citation_and_Style_Manual_modified_2022.05.31.pdf](https://www.sweetstudy.com/files/ustc-citation-and-style-manual-modified-2022-05-31-pdf "USTC_Citation_and_Style_Manual_modified_2022.05.31.pdf")
\
PLRWritingAssignmentFall2025.pptx](https://www.sweetstudy.com/files/plrwritingassignmentfall2025-pptx "PLRWritingAssignmentFall2025.pptx")

November 5, 2026
[Solved] Excel spreadsheet

✓ Verified Academic Solution Available

Executive Solution Overview

Need this project completed – ## F2025Assignt2KeyCheckfigures.xlsx – ## F2025Excelprojectinstructions6.pdf – F2025EXCELPROJ1.xls **## F2025Assignt2KeyCheckfigures.xlsx** ## Sheet1 | | | | | | | — | — | — | — | — | | Key Check Figures | | Schedules | | Schedule B | July | August | September…

Instant Solution Download
$6.99

Immediate access to the full model answer, formatted citations, and rubric breakdown.

Need a Fresh Custom Paper?

Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →

Assignment Prompt & Instructions

Need this project completed

– ## F2025Assignt2KeyCheckfigures.xlsx

– ## F2025Excelprojectinstructions6.pdf

– F2025EXCELPROJ1.xls

**## F2025Assignt2KeyCheckfigures.xlsx**

## Sheet1

| | | | | |
| — | — | — | — | — |
| Key Check Figures |
| Schedules |
| Schedule B | July | August | September | Sched E15 |
| Total collections | $2,274,993 | $2,572,479 | $2,858,704 | $929,200 |
| Schedule D |
| COGS | $1,692,384 | $1,909,842 | $2,156,968 |

| Schedule E |
| Total Payments | $2,076,010 | $1,985,264 | $2,177,350 |
| Projected Income statements |
| Net Income before Taxes | $125,877 | $161,323 | $203,086 |
| Projected Balance Seet | September |
| Accounts Receivable | $3,079,662 |
| Inventory | $1,587,432 |
| Fixed Assets, net of depreciation | $1,522,000 |
| Total Assets | $6,230,594 |
| Accounts Payable | $896,796 |
| Projected SCF | July | August | September |
| Cash excess (deficit) | -$527,715 | -$166,635 | -$206,252 |

**## F2025Excelprojectinstructions6.pdf**

1

EXCEL PROJECT: FINANCIAL PLANNING AND MODELING CASE

(100 points)

GENERAL INSTRUCTIONS: READ THIS ENTIRE ASSIGNMENT CAREFULLY

BEFORE STARTING YOUR WORK. Failure to follow the instructions will result in point

deductions. Late Projects will be subject to a 10 point for each day (or a fraction of a day) and

will not be accepted after the third day following the deadline.

Download all files from the Canvas course page, including the accompanying excel template,

and save

them. DO NOT COPY AND PASTE THE EXCEL TEMPLATE INTO A NEW

WORKBOOK AND DO NOT WORK THROUGH THE WEB BROWSER. Use formulas

in all spreadsheet cells and reference given data cells as necessary. You will NOT earn credit

for ENTERING HARDCODED VALUES. BE SURE TO REGULARLY SAVE YOUR

WORK. Excuses about lost work will not be accepted. Maintain a second (backup) copy of

your file as well.

PROJECT OBJECTIVES

The project requires to complete an Excel-based financial model template. Such models are

extensively used in business planning, decision-making, and for obtaining business financing.,

making but also emphasizes critical thinking and general business skills. Specifically, the case

has the following objectives: (1) to obtain experience using Excel within a planning and decision

context; (2) to integrate a range of managerial and financial accounting concepts; and (3) to

reinforce financial statement relationships through linking projected financial statements.

You will complete a financial planning model that is derived from a set of assumptions and link

together statements of projected cash, income and balance sheets that articulate. An Excel

template, which is available for downloading, is structured with a separate worksheet (or tab) for

each of the following sections: Sheet (1) Assumptions; Sheet (2) Supporting Schedules; Sheet (3)

Projected Income Statement and Balance Sheet; and Sheet (4) Projected Cash Flow.

Sheet (2) provides supporting schedules for detailed computations, which in turn links to the

projected income statements and balance sheet contained within Sheet (3), along with projected

cash flow in Sheet (4).

2

To work correctly, all cells of your model should be linked together via formulas, or cell

references, across all worksheets. (A 5th sheet labeled, Graph contains data to produce a cost-

volume-profit graph from current period, baseline information. You should use the ChartWizard

in Excel to create the graph. The Excel template already contains the key assumptions as well as

some formulas.

Within a real-life practice situation, you would need to independently develop and obtain support

for the necessary assumptions that have been provided to you. In Part I of the Excel case, you

should complete the model formulas and linkages to Sheets (2), (3) and (4

To accomplish this, the financial model must articulate (i.e., interconnect, or link) across all

schedules and statements. Thus, a change in assumption should flow through and automatically

update all related schedules in Sheet (2) and projected statements in Sheets (3) and (4). This

requires entering formulas within the cells to calculate the required values, rather than

hardcoding values into the cells.

OUT-WEST PRODUCTS, INC. CASE

You’re Hired!

Cynthia Valley formed Out-West Products, Inc. (OWP) in 2020 when she obtained an exclusive

franchise to nationally distribute a pen-based input device that provides effortless communication

with standard personal computers. Recent high sales growth of the base model pen-based input

device (PID-B), along with expected sales growth for a new premium model (PID-P), requires

adding new management team members. The Company hires you as a management trainee to

assume direct responsibility for financial planning activities. Your first assignment is to prepare

a financial plan for the next three months, starting July 1.

CASH COOLECTION PATTERN is as follows:

30% of a month’s sales are collected by month-end. An additional 40% is collected in the

month following, and the remaining 30% is collected in the second month following sale.

Thus far bad debts have been negligible.

Since OWP’s policy is to never stock out of its pen-based input devices (PIDs), and potentially

forfeit market share to competitors, the Company maintains fairly high inventory levels.

Therefore, desired ending inventories are equal to 70% of the next month’s sales in units.

3

Prior to June, OWP sold only the basic model PID-B at a price of $230 per unit. The PID-B

costs OutWest Products $155 each from the manufacturer and it pays for purchases as follows:

CASH Disbursements PATTERN is as follows:

60% in the month of purchase and the remaining 40% the following month.

The company’s monthly operating expenses (organized by cost behavior) are also provided in the

Assumptions Sheet of the excel template. All operating expenses are paid during the month, in

cash, with the exception of depreciation and insurance expenses.

New fixed assets, including personal computers and office furniture, will be purchased

during September for $90,000 cash. Ignore depreciation for these newly acquired since they

are insignificant. The Company declares dividends of $20,000 each quarter, payable in the

first month of the following quarter.

OWP’s actual balance sheet at June 30, 2020 is provided at the end of the template’s

Assumptions Sheet.

However, the Company also desires a minimum ending cash balance each month of $35,000

to meet regular operating expenses. Assume borrowings occur at the beginning of the

period. To further simplify, assume no tax consequences.

REQUIRED:

Financial Planning Model (100 Points)

Download the Excel template from your Blackboard course page – DO NOT MODIFY THE

FORMAT OF THE TEMPLATE. Save the file and do not attempt to complete the template

directly from the course page and do not copy and paste sheets into a new workbook. Case

assumptions have already been provided in the template’s assumptions sheet. If necessary, it

may be helpful to review Chapter 3 (CVP Analysis) and Chapter 6 (Budgeting) in your textbook

prior to beginning the project. Be sure to regularly save your work as you complete the

model. Remember that you must use formulas so that any changes in input data

automatically update your model. Otherwise, your model will not work adequately, and

you will lose points. First, complete the sheets of the Excel template, as indicated below.

Complete Sheet 2 (Schedules)

1) Sales and merchandise purchase plans with supporting schedules. (40 points)

4

a) A sales plan by month and in total – including a schedule of projected cash collections

from sales

and accounts receivable, by month and in total.

b) A purchases plan in units and in dollars, including a schedule of projected cash payments

for

purchases, by month and in total.

[Note: The cost of inventory on hand is released to cost of goods sold before costs for the

purchase of additional units (i.e., use a FIFO cost flow assumption for all months).]

Complete Sheet 3 (Inc. St. and Bal. Sheet)

2) Projected contribution format income statements by month and in total. (20 points)

3) Projected balance sheet for the quarter as of September30. (20 points)

Complete Sheet 4 (Statements of Cash Flow)

4) Projected statements of cash by month and in total – internal budget format. (15 points)

Graph (5 points)

Use the data in the Graph worksheet to create a cost-volume-profit graph.

Highlight the cells A13:H16. Click insert and Select a line chart type for the CVP graph (your

choice of style).

Be sure that your graph closely resembles a standard CVP graph or points will not be awarded.

**F2025EXCELPROJ1.xls**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/f2025excelproj1-xls-10456445)

**F2025EXCELPROJ1.xls**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/f2025excelproj1-xls-10456445)

**## F2025Assignt2KeyCheckfigures.xlsx**

## Sheet1

| | | | | |
| — | — | — | — | — |
| Key Check Figures |
| Schedules |
| Schedule B | July | August | September | Sched E15 |
| Total collections | $2,274,993 | $2,572,479 | $2,858,704 | $929,200 |
| Schedule D |
| COGS | $1,692,384 | $1,909,842 | $2,156,968 |

| Schedule E |
| Total Payments | $2,076,010 | $1,985,264 | $2,177,350 |
| Projected Income statements |
| Net Income before Taxes | $125,877 | $161,323 | $203,086 |
| Projected Balance Seet | September |
| Accounts Receivable | $3,079,662 |
| Inventory | $1,587,432 |
| Fixed Assets, net of depreciation | $1,522,000 |
| Total Assets | $6,230,594 |
| Accounts Payable | $896,796 |
| Projected SCF | July | August | September |
| Cash excess (deficit) | -$527,715 | -$166,635 | -$206,252 |

**## F2025Excelprojectinstructions6.pdf**

1

EXCEL PROJECT: FINANCIAL PLANNING AND MODELING CASE

(100 points)

GENERAL INSTRUCTIONS: READ THIS ENTIRE ASSIGNMENT CAREFULLY

BEFORE STARTING YOUR WORK. Failure to follow the instructions will result in point

deductions. Late Projects will be subject to a 10 point for each day (or a fraction of a day) and

will not be accepted after the third day following the deadline.

Download all files from the Canvas course page, including the accompanying excel template,

and save

them. DO NOT COPY AND PASTE THE EXCEL TEMPLATE INTO A NEW

WORKBOOK AND DO NOT WORK THROUGH THE WEB BROWSER. Use formulas

in all spreadsheet cells and reference given data cells as necessary. You will NOT earn credit

for ENTERING HARDCODED VALUES. BE SURE TO REGULARLY SAVE YOUR

WORK. Excuses about lost work will not be accepted. Maintain a second (backup) copy of

your file as well.

PROJECT OBJECTIVES

The project requires to complete an Excel-based financial model template. Such models are

extensively used in business planning, decision-making, and for obtaining business financing.,

making but also emphasizes critical thinking and general business skills. Specifically, the case

has the following objectives: (1) to obtain experience using Excel within a planning and decision

context; (2) to integrate a range of managerial and financial accounting concepts; and (3) to

reinforce financial statement relationships through linking projected financial statements.

You will complete a financial planning model that is derived from a set of assumptions and link

together statements of projected cash, income and balance sheets that articulate. An Excel

template, which is available for downloading, is structured with a separate worksheet (or tab) for

each of the following sections: Sheet (1) Assumptions; Sheet (2) Supporting Schedules; Sheet (3)

Projected Income Statement and Balance Sheet; and Sheet (4) Projected Cash Flow.

Sheet (2) provides supporting schedules for detailed computations, which in turn links to the

projected income statements and balance sheet contained within Sheet (3), along with projected

cash flow in Sheet (4).

2

To work correctly, all cells of your model should be linked together via formulas, or cell

references, across all worksheets. (A 5th sheet labeled, Graph contains data to produce a cost-

volume-profit graph from current period, baseline information. You should use the ChartWizard

in Excel to create the graph. The Excel template already contains the key assumptions as well as

some formulas.

Within a real-life practice situation, you would need to independently develop and obtain support

for the necessary assumptions that have been provided to you. In Part I of the Excel case, you

should complete the model formulas and linkages to Sheets (2), (3) and (4

To accomplish this, the financial model must articulate (i.e., interconnect, or link) across all

schedules and statements. Thus, a change in assumption should flow through and automatically

update all related schedules in Sheet (2) and projected statements in Sheets (3) and (4). This

requires entering formulas within the cells to calculate the required values, rather than

hardcoding values into the cells.

OUT-WEST PRODUCTS, INC. CASE

You’re Hired!

Cynthia Valley formed Out-West Products, Inc. (OWP) in 2020 when she obtained an exclusive

franchise to nationally distribute a pen-based input device that provides effortless communication

with standard personal computers. Recent high sales growth of the base model pen-based input

device (PID-B), along with expected sales growth for a new premium model (PID-P), requires

adding new management team members. The Company hires you as a management trainee to

assume direct responsibility for financial planning activities. Your first assignment is to prepare

a financial plan for the next three months, starting July 1.

CASH COOLECTION PATTERN is as follows:

30% of a month’s sales are collected by month-end. An additional 40% is collected in the

month following, and the remaining 30% is collected in the second month following sale.

Thus far bad debts have been negligible.

Since OWP’s policy is to never stock out of its pen-based input devices (PIDs), and potentially

forfeit market share to competitors, the Company maintains fairly high inventory levels.

Therefore, desired ending inventories are equal to 70% of the next month’s sales in units.

3

Prior to June, OWP sold only the basic model PID-B at a price of $230 per unit. The PID-B

costs OutWest Products $155 each from the manufacturer and it pays for purchases as follows:

CASH Disbursements PATTERN is as follows:

60% in the month of purchase and the remaining 40% the following month.

The company’s monthly operating expenses (organized by cost behavior) are also provided in the

Assumptions Sheet of the excel template. All operating expenses are paid during the month, in

cash, with the exception of depreciation and insurance expenses.

New fixed assets, including personal computers and office furniture, will be purchased

during September for $90,000 cash. Ignore depreciation for these newly acquired since they

are insignificant. The Company declares dividends of $20,000 each quarter, payable in the

first month of the following quarter.

OWP’s actual balance sheet at June 30, 2020 is provided at the end of the template’s

Assumptions Sheet.

However, the Company also desires a minimum ending cash balance each month of $35,000

to meet regular operating expenses. Assume borrowings occur at the beginning of the

period. To further simplify, assume no tax consequences.

REQUIRED:

Financial Planning Model (100 Points)

Download the Excel template from your Blackboard course page – DO NOT MODIFY THE

FORMAT OF THE TEMPLATE. Save the file and do not attempt to complete the template

directly from the course page and do not copy and paste sheets into a new workbook. Case

assumptions have already been provided in the template’s assumptions sheet. If necessary, it

may be helpful to review Chapter 3 (CVP Analysis) and Chapter 6 (Budgeting) in your textbook

prior to beginning the project. Be sure to regularly save your work as you complete the

model. Remember that you must use formulas so that any changes in input data

automatically update your model. Otherwise, your model will not work adequately, and

you will lose points. First, complete the sheets of the Excel template, as indicated below.

Complete Sheet 2 (Schedules)

1) Sales and merchandise purchase plans with supporting schedules. (40 points)

4

a) A sales plan by month and in total – including a schedule of projected cash collections

from sales

and accounts receivable, by month and in total.

b) A purchases plan in units and in dollars, including a schedule of projected cash payments

for

purchases, by month and in total.

[Note: The cost of inventory on hand is released to cost of goods sold before costs for the

purchase of additional units (i.e., use a FIFO cost flow assumption for all months).]

Complete Sheet 3 (Inc. St. and Bal. Sheet)

2) Projected contribution format income statements by month and in total. (20 points)

3) Projected balance sheet for the quarter as of September30. (20 points)

Complete Sheet 4 (Statements of Cash Flow)

4) Projected statements of cash by month and in total – internal budget format. (15 points)

Graph (5 points)

Use the data in the Graph worksheet to create a cost-volume-profit graph.

Highlight the cells A13:H16. Click insert and Select a line chart type for the CVP graph (your

choice of style).

Be sure that your graph closely resembles a standard CVP graph or points will not be awarded.

**F2025EXCELPROJ1.xls**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/f2025excelproj1-xls-10456445)

**## F2025Assignt2KeyCheckfigures.xlsx**

## Sheet1

| | | | | |
| — | — | — | — | — |
| Key Check Figures |
| Schedules |
| Schedule B | July | August | September | Sched E15 |
| Total collections | $2,274,993 | $2,572,479 | $2,858,704 | $929,200 |
| Schedule D |
| COGS | $1,692,384 | $1,909,842 | $2,156,968 |

| Schedule E |
| Total Payments | $2,076,010 | $1,985,264 | $2,177,350 |
| Projected Income statements |
| Net Income before Taxes | $125,877 | $161,323 | $203,086 |
| Projected Balance Seet | September |
| Accounts Receivable | $3,079,662 |
| Inventory | $1,587,432 |
| Fixed Assets, net of depreciation | $1,522,000 |
| Total Assets | $6,230,594 |
| Accounts Payable | $896,796 |
| Projected SCF | July | August | September |
| Cash excess (deficit) | -$527,715 | -$166,635 | -$206,252 |

**## F2025Excelprojectinstructions6.pdf**

1

EXCEL PROJECT: FINANCIAL PLANNING AND MODELING CASE

(100 points)

GENERAL INSTRUCTIONS: READ THIS ENTIRE ASSIGNMENT CAREFULLY

BEFORE STARTING YOUR WORK. Failure to follow the instructions will result in point

deductions. Late Projects will be subject to a 10 point for each day (or a fraction of a day) and

will not be accepted after the third day following the deadline.

Download all files from the Canvas course page, including the accompanying excel template,

and save

them. DO NOT COPY AND PASTE THE EXCEL TEMPLATE INTO A NEW

WORKBOOK AND DO NOT WORK THROUGH THE WEB BROWSER. Use formulas

in all spreadsheet cells and reference given data cells as necessary. You will NOT earn credit

for ENTERING HARDCODED VALUES. BE SURE TO REGULARLY SAVE YOUR

WORK. Excuses about lost work will not be accepted. Maintain a second (backup) copy of

your file as well.

PROJECT OBJECTIVES

The project requires to complete an Excel-based financial model template. Such models are

extensively used in business planning, decision-making, and for obtaining business financing.,

making but also emphasizes critical thinking and general business skills. Specifically, the case

has the following objectives: (1) to obtain experience using Excel within a planning and decision

context; (2) to integrate a range of managerial and financial accounting concepts; and (3) to

reinforce financial statement relationships through linking projected financial statements.

You will complete a financial planning model that is derived from a set of assumptions and link

together statements of projected cash, income and balance sheets that articulate. An Excel

template, which is available for downloading, is structured with a separate worksheet (or tab) for

each of the following sections: Sheet (1) Assumptions; Sheet (2) Supporting Schedules; Sheet (3)

Projected Income Statement and Balance Sheet; and Sheet (4) Projected Cash Flow.

Sheet (2) provides supporting schedules for detailed computations, which in turn links to the

projected income statements and balance sheet contained within Sheet (3), along with projected

cash flow in Sheet (4).

2

To work correctly, all cells of your model should be linked together via formulas, or cell

references, across all worksheets. (A 5th sheet labeled, Graph contains data to produce a cost-

volume-profit graph from current period, baseline information. You should use the ChartWizard

in Excel to create the graph. The Excel template already contains the key assumptions as well as

some formulas.

Within a real-life practice situation, you would need to independently develop and obtain support

for the necessary assumptions that have been provided to you. In Part I of the Excel case, you

should complete the model formulas and linkages to Sheets (2), (3) and (4

To accomplish this, the financial model must articulate (i.e., interconnect, or link) across all

schedules and statements. Thus, a change in assumption should flow through and automatically

update all related schedules in Sheet (2) and projected statements in Sheets (3) and (4). This

requires entering formulas within the cells to calculate the required values, rather than

hardcoding values into the cells.

OUT-WEST PRODUCTS, INC. CASE

You’re Hired!

Cynthia Valley formed Out-West Products, Inc. (OWP) in 2020 when she obtained an exclusive

franchise to nationally distribute a pen-based input device that provides effortless communication

with standard personal computers. Recent high sales growth of the base model pen-based input

device (PID-B), along with expected sales growth for a new premium model (PID-P), requires

adding new management team members. The Company hires you as a management trainee to

assume direct responsibility for financial planning activities. Your first assignment is to prepare

a financial plan for the next three months, starting July 1.

CASH COOLECTION PATTERN is as follows:

30% of a month’s sales are collected by month-end. An additional 40% is collected in the

month following, and the remaining 30% is collected in the second month following sale.

Thus far bad debts have been negligible.

Since OWP’s policy is to never stock out of its pen-based input devices (PIDs), and potentially

forfeit market share to competitors, the Company maintains fairly high inventory levels.

Therefore, desired ending inventories are equal to 70% of the next month’s sales in units.

3

Prior to June, OWP sold only the basic model PID-B at a price of $230 per unit. The PID-B

costs OutWest Products $155 each from the manufacturer and it pays for purchases as follows:

CASH Disbursements PATTERN is as follows:

60% in the month of purchase and the remaining 40% the following month.

The company’s monthly operating expenses (organized by cost behavior) are also provided in the

Assumptions Sheet of the excel template. All operating expenses are paid during the month, in

cash, with the exception of depreciation and insurance expenses.

New fixed assets, including personal computers and office furniture, will be purchased

during September for $90,000 cash. Ignore depreciation for these newly acquired since they

are insignificant. The Company declares dividends of $20,000 each quarter, payable in the

first month of the following quarter.

OWP’s actual balance sheet at June 30, 2020 is provided at the end of the template’s

Assumptions Sheet.

However, the Company also desires a minimum ending cash balance each month of $35,000

to meet regular operating expenses. Assume borrowings occur at the beginning of the

period. To further simplify, assume no tax consequences.

REQUIRED:

Financial Planning Model (100 Points)

Download the Excel template from your Blackboard course page – DO NOT MODIFY THE

FORMAT OF THE TEMPLATE. Save the file and do not attempt to complete the template

directly from the course page and do not copy and paste sheets into a new workbook. Case

assumptions have already been provided in the template’s assumptions sheet. If necessary, it

may be helpful to review Chapter 3 (CVP Analysis) and Chapter 6 (Budgeting) in your textbook

prior to beginning the project. Be sure to regularly save your work as you complete the

model. Remember that you must use formulas so that any changes in input data

automatically update your model. Otherwise, your model will not work adequately, and

you will lose points. First, complete the sheets of the Excel template, as indicated below.

Complete Sheet 2 (Schedules)

1) Sales and merchandise purchase plans with supporting schedules. (40 points)

4

a) A sales plan by month and in total – including a schedule of projected cash collections

from sales

and accounts receivable, by month and in total.

b) A purchases plan in units and in dollars, including a schedule of projected cash payments

for

purchases, by month and in total.

[Note: The cost of inventory on hand is released to cost of goods sold before costs for the

purchase of additional units (i.e., use a FIFO cost flow assumption for all months).]

Complete Sheet 3 (Inc. St. and Bal. Sheet)

2) Projected contribution format income statements by month and in total. (20 points)

3) Projected balance sheet for the quarter as of September30. (20 points)

Complete Sheet 4 (Statements of Cash Flow)

4) Projected statements of cash by month and in total – internal budget format. (15 points)

Graph (5 points)

Use the data in the Graph worksheet to create a cost-volume-profit graph.

Highlight the cells A13:H16. Click insert and Select a line chart type for the CVP graph (your

choice of style).

Be sure that your graph closely resembles a standard CVP graph or points will not be awarded.

**F2025EXCELPROJ1.xls**

This file is too large to display. [View in new window](https://www.sweetstudy.com/files/f2025excelproj1-xls-10456445)

– 1
– 2
– 3

November 5, 2026
[Solved] Due the 19th

✓ Verified Academic Solution Available

Executive Solution Overview

**Write two posts (one initial and one reply, 200-300 words per post) on the following topic:** **Tableau Reflection** **Watch this video:** [**https://www.tableau.com/learn/tutorials/on-demand/relationships?playlist=296807Links to an external site.**](https://www.tableau.com/learn/tutorials/on-dema…

Instant Solution Download
$6.99

Immediate access to the full model answer, formatted citations, and rubric breakdown.

Need a Fresh Custom Paper?

Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →

Assignment Prompt & Instructions

**Write two posts (one initial and one reply, 200-300 words per post) on the following topic:**
**Tableau Reflection**
**Watch this video:** [**https://www.tableau.com/learn/tutorials/on-demand/relationships?playlist=296807Links to an external site.**](https://www.tableau.com/learn/tutorials/on-demand/relationships?playlist=296807) **Download this spreadsheet:** [**https://www.tableau.com/sites/default/files/convenience_store.xlsxLinks to an external site.**](https://www.tableau.com/sites/default/files/convenience_store.xlsx) **\*\* Follow along with the video and create your own Tableau workbook.When you are finished with your workbook, post it in this forum to share with the class. 1. Are you getting more comfortable with Tableau? 2. Explain the importance of relationships. 3. Answer the following questions based on your Tableau exercise.a. What were the best and worst-selling products? b. What was the contribution margin (CM) per product?c. What were the sales revenue, profit, and profit margin per category and product?d. Who were the most frequent customers?e. Who are the most profitable customers?f. From which categories did each customer purchase? And in what quantity?**

November 5, 2026
[Solved] Kelly Mooved

✓ Verified Academic Solution Available

Executive Solution Overview

In-depth study guidance and analytical solution covering Kelly Mooved.

Instant Solution Download
$6.99

Immediate access to the full model answer, formatted citations, and rubric breakdown.

Need a Fresh Custom Paper?

Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →

Assignment Prompt & Instructions

Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

November 5, 2026