Sound Effects Audio Systems Sells and Installs Car Stereo Systems

question 134

Essay

Sound Effects Audio Systems sells and installs car stereo systems.Managers need to prepare an inventory purchases budget for the first quarter of Year 2.The company's sales budget for the first quarter is provided below:
$\begin{array}{c}\begin{array}{|l|}\hline \\\hline \text {Budgeted}\\\text {Sales}\\\hline \end{array}\begin{array}{c|}\hline \text {January}\\\hline\\\$ \quad 200,000\\\hline\end{array}\begin{array}{c|}\hline \text {February}\\\hline\\\$ \quad 196,000\\\hline\end{array}\begin{array}{c|}\hline \text {March}\\\hline\\ \$ \quad180,000\\\hline\end{array}\end{array}$
Based on past experience the company expects the cost of goods sold to equal 80% of sales.Furthermore,the ending inventory balance each month should be $8,000 plus 20% of the current period's cost of goods sold.The inventory balance on December 31,Year 1 was $34,000.The company makes all purchases on account and pays 60% of accounts payable in the month of purchase and the remaining 40% in the next month.Accounts payable stood at $36,000 at December 31,Year 1.
Required:
1)Prepare an inventory purchases budget for January,February,and March of Year 2.
2)Determine the amount of ending inventory and the accounts payable balance that will appear on the March 31,Year 2 pro forma balance sheet.
3)Prepare a schedule of cash payments for inventory for January,February,and March,Year 2.

---

Definitions:

Just In Time

A management strategy that aligns raw-material orders from suppliers directly with production schedules to increase efficiency and reduce waste.

Continuous Improvement

An ongoing effort to improve products, services, or processes through incremental and breakthrough improvements.

Quality Circles

Small groups of employees who voluntarily meet on a regular basis to identify, analyze, and solve work-related problems, typically focusing on quality improvement.

NLRA

Refers to the National Labor Relations Act of 1935, U.S. legislation that protects the rights of employees and employers, to encourage collective bargaining, and to curtail certain private sector labor and management practices.