Solved

Hi-Value Products Company Is Creating an Operating Budget for the 3rd

Question 54

Essay

Hi-value Products Company is creating an operating budget for the 3rd quarter. Please review the following budgets:
 Sales Budget  Jul  Aug  Sep  Cash sales: 75%$75,000$90,000$120,000 Credit sales: 25%25,00030,00040,000 Total sales $100,000$120,000$160,000 Inventory, Purchases and COGS. Budget  Jul  Aug  Sep  Cost of goods sold $60,000$72,000$96,000 Desired ending inventory 38,00050,00062,000 Total inventory required 98,000122,000158,000 ess Beginning inventory (50,000)(38,000)(50,000 Purchases $48,000$84,000$108,000\begin{array}{|l|c|c|c|}\hline\text { Sales Budget }&\text { Jul } & \text { Aug } & \text { Sep } \\\hline \text { Cash sales: } 75 \% & \$ 75,000 & \$ 90,000 &\$120,000\\\hline \text { Credit sales: } 25 \% & 25,000 & 30,000 &40,000\\\hline \text { Total sales } & \$ 100,000 & \$ 120,000 & \$ 160,000\\\hline\\\hline\text { Inventory, Purchases and COGS. Budget }&\text { Jul } & \text { Aug } & \text { Sep }\\\hline \text { Cost of goods sold } & \$ 60,000 & \$ 72,000 & \$ 96,000 \\\hline \text { Desired ending inventory } & 38,000 & 50,000 & 62,000 \\\hline \text { Total inventory required } & 98,000 & 122,000 & 158,000 \\\hline \text { ess Beginning inventory } & (50,000) & (38,000) & (50,000 \\\hline \text { Purchases } & \$ 48,000 & \$ 84,000 & \$ 108,000 \\\hline \end{array}
 Operating Expenses Budget  Jul  Aug  Sep  Variable operating expenses:  Misc. expense (10% of sales) $10,000$12,000$16,000 Total variable expenses 10,00012,00016,000 Fixed operating expenses:  Salary expense 12,00012,00012,000 Rent expense 8,0008,0008,000 Depreciation expense 5,6005,6005,600 Misc. expense(fixed portion) 4,2004,2004,200 Total fixed expenses 29,80029,80029,800 Total operating expenses $39,800$41,800$45,800\begin{array}{|l|r|r|r|}\hline\text { Operating Expenses Budget } & \text { Jul } & \text { Aug } & \text { Sep } \\\hline \text { Variable operating expenses: } & & & \\\hline \text { Misc. expense }(10 \% \text { of sales) } & \$ 10,000 & \$ 12,000 & \$ 16,000 \\\hline \text { Total variable expenses } & 10,000 & 12,000 & 16,000 \\\hline \text { Fixed operating expenses: } & & & \\\hline \text { Salary expense } & 12,000 & 12,000 & 12,000 \\\hline \text { Rent expense } & 8,000 & 8,000 & 8,000 \\\hline \text { Depreciation expense } & 5,600 & 5,600 & 5,600 \\\hline \text { Misc. expense(fixed portion) } & 4,200 & 4,200 & 4,200 \\\hline \text { Total fixed expenses } & 29,800 & 29,800 & 29,800 \\\hline \text { Total operating expenses } & \$ 39,800 & \$ 41,800 & \$ 45,800 \\\hline\end{array}

Using the format below, please prepare a budgeted income statement.
 Budgeted Income Statement  Jul  Aug  Sep  Sales revenue  Cost of goods sold  Gross profit  Variable operating expenses:  Misc. expense  Total variable expenses  Contribution margin  Fixed operating expenses  Salary expense  Rent expense  Depreciation expense  Misc. expense(fixed portion)  Total fixed expenses  Operating income/(loss)  Interest expense  Net income/(loss) \begin{array} { | l | l | l | l | } \hline \text { Budgeted Income Statement } & \text { Jul } & \text { Aug } & \text { Sep } \\\hline \text { Sales revenue } & & & \\\hline \text { Cost of goods sold } & & & \\\hline \text { Gross profit } & & & \\\hline \text { Variable operating expenses: } & & & \\\hline \text { Misc. expense } & & & \\\hline \text { Total variable expenses } & & & \\\hline \text { Contribution margin } & & & \\\hline \text { Fixed operating expenses } & & & \\\hline \text { Salary expense } & & & \\\hline \text { Rent expense } & & & \\\hline \text { Depreciation expense } & & & \\\hline \text { Misc. expense(fixed portion) } & & & \\\hline \text { Total fixed expenses } & & & \\\hline \text { Operating income/(loss) } & & & \\\hline \text { Interest expense } & & & \\\hline \text { Net income/(loss) } & & & \\\hline\end{array}

Correct Answer:

verifed

Verified

This question is not...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents