Concept explainers
Exercise 7-9A Determining the amount of expected inventory purchases and cash payments
Nunn Company, which sells electric razors, had $200,000 of cost of goods sold during the month of June. The company projects a 5 percent increase in cost of goods sold during July. The inventory balance as of June 30 is $15,000, and the desired ending inventory balance for July is $16,000. Nunn pays cash to settle 70 percent of its purchases on account during the month of purchase and pays the remaining 30 percent in the month following the purchase. The accounts payable balance as of June 30 was $18,000.
Required
a. Determine the amount of purchases budgeted for July.
b. Determine the amount of
Want to see the full answer?
Check out a sample textbook solutionChapter 14 Solutions
Survey Of Accounting
- Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.arrow_forwardPreparing a Short-Term Cash Forecast The Lyon Corporation is a merchandising company. Prepare a short-term cash forecast for July of Year 6 following the format of Exhibit 9A.4. Selected financial data from Lyon Corporation as of July 1 of Year 6 are reproduced below ($ thousands): Additional Information: Gross profit equals 20% of cost of goods sold. Lyon purchases all inventory on the second day of the month and receives it the following week. Lyon pays 75% of payables within the month of purchase and the balance in the following month. Lyons pays all remaining expenses in cash.arrow_forwardstimated finished goods inventory balance at the end of July? 13. What is the estimated cost of goods sold and gross margin for July? 14. What is the estimated total selling and administrative expense for July? 15. What is the estimated net operating income for July? Connect EXERCISE 8-1 Schedule of Expected Cash Collections LO8-2 Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below- April May June Total Budgeted sales (all on account) $300,000 $500,000 $200,000 $1,000,000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000. Required: Using Schedule 1 as…arrow_forward
- 4 Jasper Company has 70% of its sales on credit and 30% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $525,000 for April, $535,000 for May, and $560,000 for June. Total sales for March are $500,000. Prepare a schedule of cash receipts from sales for April, May, and June, ts Book erences Sales Cash receipts from: Total cash receipts JASPER COMPANY Schedule of Cash Receipts from Sales April 525,000 May 535,000 June 560,000arrow_forwardAssume a merchandising company’s estimated sales for January, February, and March are $101,000, $121,000, and $111,000, respectively. Its cost of goods sold is always 30% of its sales. The company always maintains ending merchandise inventory equal to 10% of next month’s cost of goods sold. What are the required merchandise purchases for January? Multiple Choice $29,700 $33,740 $36,300 $30,900arrow_forwarded ok ces Shadee Corporation expects to sell 530 sun shades in May and 330 in June. Each shades sells for $12. Shadee's beginning and ending finished goods inventories for May are 70 and 60 shades, respectively. Ending finished goods inventory for June will be 60 shades. It expects the following unit sales for the third quarter: July August September 545 470 460 Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale, 37 percent is collected during the following month, and 11 percent is never collected. Required: Calculate Shadee's total cash receipts for August and September. Note: Do not round your intermediate calculations. Round your answers to the nearest whole dollar. Total Cash Receipts August Septemberarrow_forward
- Problem 1 Gemini Company started business at the beginning of the current year. The entity established an allowance for doubtful accounts estimated at 5% of credit sales. During the year, the entity wrote off P50,000 of uncollectible accounts. Further analysis showed that merchandise purchased amounted to P9,000,000 and ending merchandise inventory was P1,500,000. Goods were sold at 40% above cost. The total sales comprised 80% sales on account and 20% cash sales. Total collections from customers, excluding cash sales, amounted to P6,000,000. 1. What is the amount of cost of goods sold? 2. What is the amount of sales on account? 3. What is the net realizable value of accounts receivable at year-end?_arrow_forward1. Bulk Wholesalers took in $378,800 in sales during July. They started the month with inventory worth $173,800 and spent $292,900 on new purchases during the month. Gross margin on sales was 76%. Using the gross profit method, estimate the cost value of the inventory at the end of July. A. $90,912 B. $292,900 C. $375,788 D. $466,700 2.Find the entry you would make on an income statement for TOTAL OPERATING EXPENSES for the year ended December 31, 2007: Gross Sales, $161,000; Sales Returns and Allowances, $9,600; Sales Discounts, $15,600; Merchandise Inventory, January 1, 2011, $52,500; Merchandise Inventory, December 31, 2011, $62,500; Net Purchases, $84,300; Freight In, $3,000; Salaries, $94,300; Rent, $29,800; Utilities, $2,245; Insurance, $3,250; and Income Tax, $19,100. A. $58,500 B. $77,300 C. $129,595 D. $135,800arrow_forwardMC Qu. 9-80 Rainbow, Inc. began operations on January... Rainbow, Inc. began operations on January 1 of the current year with a $12,800 cash balance. Fifty percent of sales are collected in the month of sale; 50% are collected in the month following sale. Similarly, 10% of purchases are paid in the month of purchase, and 90% are paid in the month following purchase. The following data apply to January and February: January February Sales $ 43,000 $ 63,000 Purchases 34,000 48,000 Operating expenses 7,800 9,800 If operating expenses are paid in the month incurred and include monthly depreciation charges of $3,300, determine the change in Rainbow’s cash balance during February. Multiple Choice $7,800 increase. $11,100 increase. $16,900 increase. $20,200 increase. None of the answers is correct.arrow_forward
- Question 7 : MNO Company's credit sales policy is to have: 50% of the sales amount in cash 30% collected after one month 20% after two months. The purchasing policy is to pay 60% in cash and the rest is to be paid after one month. Required: Calculate the net accounting profit for December. Calculate the net cash flow for December. Comment on the difference between the two previous answers. Item October November December Sales 400,000 350,000 450,000 Purchases 350,000 340,000 420,000arrow_forwardAssume a merchandising company's estimated sales for January, February, and March are $107,000, $ 127,000, and $117,000, respectively. Its cost of goods sold is always 60% of its sales. The company always maintains ending merchandise inventory equal to 20% of next month's cost of goods sold. It pays for 20% of its merchandise purchases in the month of the purchase and the remaining 80% in the subsequent month. What are the cash disbursements for merchandise purchases that would appear in the company's cash budget for February? Multiple Choice $68,280 $65, 280 $71,280 $70,280arrow_forwardAssume a merchandising company’s estimated sales for January, February, and March are $105,000, $125,000, and $115,000, respectively. Its cost of goods sold is always 30% of its sales. The company always maintains ending merchandise inventory equal to 10% of next month’s cost of goods sold. What are the required merchandise purchases for January?arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning