Jimi, Inc., is preparing its m

Sigchi4life
Category:
Accounting
Price: $20 USD

Question description

Jimi, Inc., is preparing its master budget for the quarter ended December 31. It sells a single product for $55 each. Seventy percent of all sales are on credit. Cash is paid for the remaining sales. All credit sales are collected in the month following the sale. The balance in accounts receivable is $12,000 on September 30, which represents the uncollected balance on September's sales. Budgeted sales for the next four months follow: Oct 980, Nov 1200, Dec 850, Jan 1190

The unit cost is $30. The company prefers an ending inventory is 55% of the following month's sales. September's inventory is 480 units. Dane, Inc. pay for 60% of the current month's purchases and 40% in the following month. The A/P balance on September 30 is $9800, which represents unpaid purchases.
Monthly operating expenses:
- Commissions (10% of sales)
- Shipping (4.2% of sales)
-Office salaries ($750 per week-assume each month has 4 weeks)
-Rent ($5000 per month)

Depreciation is $3300 per month. Income taxes are 40%, and will be paid on March 31. There are $2500 in taxes payable on December 31. The company requires $10000 minimum monthly cash balance. The cash balance as of September is $12000. Loans are obtained at the end of any month whn the minimum cash balance is not met. Interest is 3% per month based on teh beginning of the month loan balance and is paid at the end of each month. If the monthly ending cash balance is over $10000, loans are repaid at the end of the month. As of September 30, the loan balance is $900. Prepare a master budget (round all dollar amounts to the nearest whole dollar) for each of the months of October, November, and December. Include the sales budget, table of cash receipts, merchandise purchases budget, table of cash disbursements for purchase of merchandise, Table of cash disbursements for selling and administrative expenses, cash budget, including information on the loan balance, budgeted income statement

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UT Austin
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1821 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors