60.1K

Verified Solution

Link Copied!

sleeping with the fishes Use whole numbers for all of your answers. Incorrect

Question $5$

$\frac{0}{9}$ pts

Calculate Monthly Cash Flow for Group Charters. Use whole numbers.

Hint: fixed costs for cash flow excludes depreciation expense

$\begin{array}{cc}\text{M}\text{o}\text{n}\text{t}\text{h}\text{l}\text{y}\text{C}\text{a}\text{s}\text{h}\text{F}\text{l}\text{o}\text{w}\text{f}\text{o}\text{r}\text{G}\text{r}\text{o}\text{u}\text{p}\text{C}\text{h}\text{a}\text{r}\text{t}\text{e}\text{r}\text{s}& ?\\ \text{S}\text{a}\text{l}\text{e}\text{s}& \text{D}\text{o}\text{l}\text{l}\text{a}\text{r}\text{A}\text{m}\text{o}\text{u}\text{n}\text{t}\\ \text{C}\text{r}\text{e}\text{w}& ?\\ \text{G}\text{a}\text{s}& ?\\ \text{L}\text{u}\text{n}\text{c}\text{h}& ?\\ \text{T}\text{o}\text{t}\text{a}\text{l}\text{V}\text{a}\text{r}\text{i}\text{a}\text{b}\text{l}\text{e}\text{C}\text{o}\text{s}\text{t}\text{s}& ?\\ \text{C}\text{o}\text{n}\text{t}\text{r}\text{i}\text{b}\text{u}\text{t}\text{i}\text{o}\text{n}\text{M}\text{a}\text{r}\text{g}\text{i}\text{n}& ?\\ \text{A}\text{l}\text{l}\text{o}\text{c}\text{a}\text{t}\text{e}\text{d}\text{F}\text{i}\text{x}\text{e}\text{d}\text{C}\text{o}\text{s}\text{t}\text{s}& ?\\ \text{C}\text{a}\text{s}\text{h}\text{F}\text{l}\text{o}\text{w}& ?\end{array}$

Answer $1$:

$($You left this blank$)$ Incorrect

Question $4$

$\frac{0}{9}$ pts

Calculate Monthly Cash Flow for Individually Booked Charters. Use whole numbers.

Hint: fixed costs for cash flow excludes depreciation expense

$\begin{array}{cc}\text{M}\text{o}\text{n}\text{t}\text{h}\text{l}\text{y}\text{C}\text{a}\text{s}\text{h}\text{F}\text{l}\text{o}\text{w}\text{f}\text{o}\text{r}\text{I}\text{n}\text{d}\text{i}\text{v}\text{i}\text{d}\text{u}\text{a}\text{l}\text{l}\text{y}\text{B}\text{o}\text{o}\text{k}\text{e}\text{d}\text{C}\text{h}\text{a}\text{r}\text{t}\text{e}\text{r}\text{s}& ?\\ \text{S}\text{a}\text{l}\text{e}\text{s}& \text{D}\text{o}\text{l}\text{l}\text{a}\text{r}\text{A}\text{m}\text{o}\text{u}\text{n}\text{t}\\ \text{C}\text{r}\text{e}\text{w}& ?\\ \text{G}\text{a}\text{s}& ?\\ \text{L}\text{u}\text{n}\text{c}\text{h}& ?\\ \text{T}\text{o}\text{t}\text{a}\text{l}\text{V}\text{a}\text{r}\text{i}\text{a}\text{b}\text{l}\text{e}\text{C}\text{o}\text{s}\text{t}\text{s}& ?\\ \text{C}\text{o}\text{n}\text{t}\text{r}\text{i}\text{b}\text{u}\text{t}\text{i}\text{o}\text{n}\text{M}\text{a}\text{r}\text{g}\text{i}\text{n}& ?\\ \text{A}\text{l}\text{l}\text{o}\text{c}\text{a}\text{t}\text{e}\text{d}\text{F}\text{i}\text{x}\text{e}\text{d}\text{C}\text{o}\text{s}\text{t}\text{s}& ?\\ \text{C}\text{a}\text{s}\text{h}\text{F}\text{l}\text{o}\text{w}& ?\end{array}$

Answer $1$:

$($You left this blank$)$ Partial

Question $3$

$2\mathrm{.}25/9$ pts

Calculate Monthly Net Income for Group Charters. Use whole numbers.

Monthly Net Income for GroupCharters

$\backslash$table$[[$Account$,$Dollar Amount,$],[$Sales$,,],[$Crew$,,],[$Gas$,,],[$Lunch$,,],[$Total Variable Costs,,$],[$Contribution Margin,,$],[$Net Income,,$]]$

Answer $1$: rect

Question $2$

$\frac{0}{9}$ pts

Calculate Monthly Net Income for Individually Booked Charters. Use whole numbers.

Monthly Net Income for Individually Booked Charters

$\begin{array}{cc}\text{A}\text{c}\text{c}\text{o}\text{u}\text{n}\text{t}& \text{D}\text{o}\text{l}\text{l}\text{a}\text{r}\text{A}\text{m}\text{o}\text{u}\text{n}\text{t}\\ \text{S}\text{a}\text{l}\text{e}\text{s}& ?\\ \text{C}\text{r}\text{e}\text{w}& ?\\ \text{G}\text{a}\text{s}& ?\\ \text{L}\text{u}\text{n}\text{c}\text{h}& ?\\ \text{T}\text{o}\text{t}\text{a}\text{l}\text{V}\text{a}\text{r}\text{i}\text{a}\text{b}\text{l}\text{e}\text{C}\text{o}\text{s}\text{t}\text{s}& ?\\ \text{C}\text{o}\text{n}\text{t}\text{r}\text{i}\text{b}\text{u}\text{t}\text{i}\text{o}\text{n}\text{M}\text{a}\text{r}\text{g}\text{i}\text{n}& ?\\ \text{A}\text{l}\text{l}\text{o}\text{c}\text{a}\text{t}\text{e}\text{d}\text{F}\text{i}\text{x}\text{e}\text{d}\text{C}\text{o}\text{s}\text{t}\text{s}& ?\\ \text{N}\text{e}\text{t}\text{I}\text{n}\text{c}\text{o}\text{m}\text{e}& ?\end{array}$

Answer $1$:Business Name: Sleeping With The Fishes

Note: For all calculations, assume each month has four weeks and ignore all taxes.

Luca Brazi owns a fishing boat charter business he calls Sleeping With the Fishes. He runs

charters $4$ mornings per week, three weeks per month. Luca charges $$300$ per person for his

charters. The boat can hold up to $12$ passengers, but on average he goes out each morning

with eight passengers. Groups can charter the entire boat for $$3,000.$

Luca bought the boat two years ago for $$130,000.$ He expects that he will be able to run

charters on the boat for a total of ten years. His daughter has offered to buy the boat for

$$10,000$ when he upgrades to a new one when this boat is ten years old.

For each charter, Luca hires a crew of two at a rate of $$\frac{150}{?}$ day each. The boat uses

approximately $80$ gallons of gas for each tour. Luca currently pays $$\frac{4\mathrm{.}15}{?}$ gallon at the marina.

Luca feeds his crew and guests $($including himself$)$ a lunch that costs $$12$ per person. Because

he often doesn't know how many passengers will be on a group tour, Luca purchases lunch for

$12$ passengers for group tours. Luca carries insurance that costs $$6,\frac{000}{?}$ year. His business

license costs $$\frac{624}{?}$ year and the marina slip where he keeps his boat costs $$2,\frac{000}{?}$ month. Luca

buys advertising space in various magazines for a total of $$600$ per quarter. Luca generally

books three groups per month. All other charters include passengers who have booked

individually.

Stop here and complete Part $1$ in Module $2$

Part $1$: Types of costs $(12$ points completed in Module $2)$

List all of Luca's costs and indicate whether they are fixed or variable, product or period

and direct or indirect.

What are total Monthly Fixed Costs?

How many charters are run per month?

In general, how many of the monthly charters are group charters?

In general, how many of the monthly charters are individually booked charters?

What percentage of fixed costs should be allocated to group charters?

What percentage of fixed cost should be allocated to individually booked charters?

How much fixed cost should be allocated to group charters?

How much fixed cost should be allocated to individually booked charters?

Show all imagesShow all images

Answer & Explanation Solved by verified expert

See Answer