Rogers, the owner, gives credit to a select group of customers (20 percent of sales), but all others must pay cash. Of Chelsea's credit customers, 80 percent pay her the month after the sale and 20 percent pay the following month. Chelsea pays cash for 10 percent of her purchases. The other 90 percent she pays off by the end of the next month. Chelsea's operating expenses are paid the month after incurrence. Her operating expenses are about $7,000 each month, $500 of which is depreciation. Selling expenses have a fixed and a variable component. The fixed is $1,500 a month, and the variable is 10 percent of sales. Chelsea began May with $9,000 in cash. March April Sales $130,000 140,000 Purchases $120,000 125,000

Rogers, the owner, gives credit to a select group of customers (20 percent of sales), but all others must pay cash. Of Chelsea's credit customers, 80 percent pay her the month after the sale and 20 percent pay the following month. Chelsea pays cash for 10 percent of her purchases. The other 90 percent she pays off by the end of the next month. Chelsea's operating expenses are paid the month after incurrence. Her operating expenses are about $7,000 each month, $500 of which is depreciation. Selling expenses have a fixed and a variable component. The fixed is $1,500 a month, and the variable is 10 percent of sales. Chelsea began May with $9,000 in cash. March April Sales $130,000 140,000 Purchases $120,000 125,000

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter17: Activity Resource Usage Model And Tactical Decision Making

Section: Chapter Questions

Problem 6E: Elliott, Inc., has four salaried clerks to process purchase orders. Each clerk is paid a salary of...

See similar textbooks

Similar questions

Nonnas Re-Appliance Store collects 55% of its accounts receivable in the month of sale and 40% in the month after the sale. Given the following sales, how much cash will be collected in February?
Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
Sara is considering whether to open a gadgets shop. She provided you, as a consultant, the following information: Sales of $60,000 and $72,000 are expected for July and August, respectively. All goods are sold on account. The collection pattern for Accounts Receivable is 80 percent in the month of sale and 20 percent in the month following the sale. Purchases of $40,000 and $54,000 are expected for July and August. The payment pattern for purchases is 70 percent in the month of purchase, 30 percent in the month following the purchase. Other monthly expenses are $8,000, which includes $2000 of depreciation. All operating expenses are paid in the month of their incurrence. $2,000 of cash is available on August 1, 2021. Required: Prepare the cash collection budget for the two months ending August 31, 2021 Prepare the cash budget for the two months ending August 31, 2021
Eddie sells gardening equipment, mostly to small business owners. Half of Eddie's customers pay in cash, then of the remaining customers, two thirds pay in full, the following month and the other third pay in full the month after that. Eddie's predicted sales in the next three months are: February: £1,200: March: £1,400 and April: £1,460. Based on these expectations, what is the total amount that Eddie can plan to receive from all customers in April? a. 1397 b. 1333 c. 1460 d. 2063
Diana’s Designs just recently opened as an upscale dress shop in northeast Florida. Theowner is trying to decide whether to take the discount offered from her suppliers, or whetherto pay at the end of the month. Diana’s suppliers are offering her a 3% discount if shepays within 15 days; otherwise, the balance is due 30 days after purchase. What are Diana’snominal and effective annual costs of trade credit?
Betsy's Gift Baskets sells gift baskets, on average, for $125; each gift basket costs, on average, $60. Betsy pays salaries each month of $1,300 and her store rent is $1,000 per month. She also pays sales commissions of 5% of the sales price. In May, 140 gift baskets were sold. Required: a. Prepare a traditional income statement for the month of May. b. Prepare a contributio
Jerrod Dean starts the month with a balance on his credit card of $1,060. On the 10th day of the month, he purchases $220 in clothes with his credit card. On the 15th day of the month he makes a payment on his credit card of $350. The bank charges 1.5 percent interest per month using the adjusted balance method (and excludes new purchases). What would Jerrod's finance charges be for the month? Multiple Choice $11.34 $15.90 $19.20 $13.26 $10.65
BamBam runs a small business. At the start of June she has £11737 in the bank. Revenue Bambam allows her customers one month credit period and they usually take it. Sales for the quarter are below: May £4975 June £4087 July £4842 Payments Bambam has a great relationship with suppliers has two months credit period. Payments for the quarter are below: April £1998 May £2802 June £2090 Using a cash budget what will the cash closing balance be for June. help with working
A home gods retailer offers a sales incentive program where customers receive credit towards future purchases based on the dollar amount of their purchases today. For every $10 spent, a customer receives a $1 credit to use in the next 30 days. Based upon historical trends, the firm estimates that 35% of the credits will be redeemed. In the next month, consistent with the firm’s estimate, 35% of the credits were redeemed. The entry recorded to account for the redemption of these credits (excluding the effect of the costs of sales entry): A.) Increases Liabilities, Increases Stockholders’ Equity B.) Increases Liabilities, Reduces Stockholders’ Equity C.) Reduces Liabilities, Reduces Stockholders’ Equity D.) Reduces Liabilities, Increases Stockholders’ Equity C.) No entry needed
The Katie's Card Shop sells calendars with different Colonial pictures shown for each month. The once-a- year order for each year's calendar arrives in September. From past experience the September to March demand for the calendars can be approximated by a normal distribution with mean 400 and standard deviation 100. The calendars cost $2 each, and Katie sells them for $3 each. a) If Katie throws out all unsold calendars at the end of March (i.e., salvage value is zero), how many calendars should be ordered? f Katie reduces the calendar price to $ 0.5 at the end of March and can sell all surplus calendars at this price, how many calendars should be ordered? show me how to solve this step by step in excel you are talking to a stupid person I need you to tell me in Cell A1 what to enter and so forth
Heartstrings Gift Shoppe sells an assortment of gifts for any occasion. During October, Heartstrings started a Gift-of-the-Month program. Under the terms of this program, beginning in the month of the sale, Heartstrings would select and deliver a random gift each month, over the next 12 months, to the person the customer selects as a recipient. During October, Heartstrings sold 28 of these packages for a total of $11,496 in cash.
Her predicted sales are as follows Jan Feb Mar April May June July 300 350 350 450 500 550 600 The candles cost $5 to make, and sell for $12. Roxy buys in the raw materials the month before she sells the candles. She pays a deposit of 20% when she orders and the rest the following month At the start of the year she owed $1,000 to supplier for the previous month Her customers pay 75% in the month of purchase and 25% the following month She pays rent of $1,000 on the shop in cash during the month before it is due She pays cash wages of $500 a month during the month Her other running costs are $900 a month, but this includes $200 for depreciation of the candle making machine In month 4 in the forthcoming year she intends to invest $5,000 on a new machine At the start of the year she has a Bank balance of $3,500 and is owed $600 from sales from the previous year, all of which will be collected in month 1…