Practice Assignment #$1$

ADMN$2607-$ SP$24$

Due Date: $5$:$00$ pm Thursday, May $162024$

Q$1.$ Refer to Problem $1\mathrm{.}1$ in the textbook on page $21.$

a$)$ Solve Problem $1\mathrm{.}1$ as written in the textbook.

b$)$ What is the total cost, total revenue, and profit if the actual demand is $4000$ units?

c$)$ Create an Excel model for the problems solved in Parts $($a$)$ and $($b$).$

$($Take two screenshots of the excel model, one showing the solution and one showing the formulas used $-$ you can press Ctrl $\text{'}$ to show the formula view in excel$)$

d$)$ How many units should be sold to make a monthly profit of $20\%$ of the monthly lease.

e$)$ At what production cost would you be able to breakeven if the monthly demand is $1500$ units?

Q$2.$ Read Problem $1\mathrm{.}4$ on page $21($do not solve the parts in the book$).$ Use the Excel model you created in $($Q$1)$ to find the break$-$even point for Problem $1\mathrm{.}4.$ Take a screenshot that shows your answer.

Q$3.$ Solve Problem $2\mathrm{.}3$ part $($a$)$ on page $56.$ Hint: No need to redo the whole graph. Start with the graph in the textbook and figure out what would change.

Q$4.$ Solve Problem $2\mathrm{.}5$ part $($b$)$ on page $56.$