Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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: 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 $9, 800, 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 ($5,000 per month) Depreciation is $3, 300 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 $10,000 minimum monthly cash balance. The cash balance as of September 30 is $12,000. Loans are obtained at the end of any mouth when the minimum cash balance is not met. Interest is 3% per month based on the beginning of the mouth loan balance and is paid at the end of each mouth. If the monthly ending cash balance is over $10,000, loans are repaid at the end of the mouth. As of September 30, the loan balance is S900. 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 purchases of merchandise Table of cash disbursements for selling and administrative expenses Cash budget, including information on the loan balance Budgeted income statement

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting and Analysis Using Financial Accounting Information

Authors: Charles H. Gibson

13th edition

1285401603, 1133188796, 9781285401607, 978-1133188797

More Books

Students also viewed these Accounting questions

Question

What can any retailer learn from this case? Briefly.

Answered: 1 week ago