\begin{tabular}{|l|c|c|c|c|c|} \hline & \multicolumn{3}{|c|}{ Production Budget } & & \\ \hline & April & May & June & July & August \\ \hline Unit Sales & 50 & 60 & 120 & 150 & \\ \hline Add: Ending Inventory (20\% of next & & & & \\ month's sales) & 12 & 24 & 30 & \\ \hline Total & 62 & 84 & 150 & \\ \hline Less: Beginning Inventory (ending & & & & \\ inventory from previous month) & 10 & 12 & 24 & \\ \hline Total Units Needed for Production & 52 & 72 & 126 & \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Materials Budget } \\ \hline & April & May & June & July \\ \hline Budgeted Production (units) & 52 & 72 & 126 & \\ \hline Leather required (5 sq.ft./unit) & 260 & 360 & 630 & \\ \hline Leather cost (\$7/sq.ft.) & $1,820 & $2,520 & $4,410 & \\ \hline Hardware required (2/unit) & 104 & 144 & 252 & \\ \hline Hardware cost (\$5/clasp) & $520 & $720 & $1,260 & \\ \hline Total Direct Materials cost & $2,340 & $3,240 & $5,670 & \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Production Labour } \\ \hline & April & May & June & July \\ \hline Budgeted Production & 52 & 72 & 126 & \\ \hline \end{tabular} Due: Week 7 Evaluation Weight: 10% Instructions Using the template provided for this assignment, prepare an operating budget for Amy Steele Bags for the month of July Assumptions: - budgeted sales for August is 100 bags. - trade show cost in July is $1,500 \begin{tabular}{|l|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Selling \& Administration Budget } \\ \hline & April & May & June & July \\ \hline Total Sales & $15,000 & $18,000 & $36,000 & \\ \hline Less: Sales Commission (5%) & $750 & $900 & $1,800 & \\ \hline Less: Fixed costs & $2,500 & $2,500 & $2,500 & \\ \hline Less: Advertising cost & $500 & $0 & $0 & \\ \hline Less: Trade show cost & $0 & $0 & $1,500 & \\ \hline Total Selling \& Administration Costs & $3,750 & $3,400 & $5,800 & \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|} \hline & \multicolumn{5}{|c|}{ Operating Budget } & \\ \hline & April & May & June & July \\ \hline Total Sales & $15,000 & $18,000 & $36,000 & \\ \hline Less: Direct Materials cost & $2,340 & $3,240 & $5,670 & \\ \hline Less: Production Labour cost & $3,120 & $4,320 & $7,560 & \\ \hline Less: Selling \& Admin cost & $3,750 & $3,400 & $5,800 & \\ \hline Operating Profit & $5,790 & $7,040 & $16,970 & \\ \hline \end{tabular} Operating Budget Ready & A Accessibility: Good to go 96F Rain to stop Search