Question

In: Accounting

he following is known for Tourist Trinkets, Inc: One half of all sales are on credit....

he following is known for Tourist Trinkets, Inc:

    • One half of all sales are on credit.
    • Of the credit sales, 75% are collected in the same month and 25% in the next month
    • The total sales for June were $125,000 and expected sales are $160,000 in July and $130,000 in August
    • The desired ending inventory is 15% of next month's sales in units at the end of each month
    • The gross margin percentage is 40%
    • The payments to suppliers are: 70% in same month and 30% in the following month
    • Total monthly fixed selling and administrative costs are $25,000; of this amount, depreciation expense is $10,000
    • All cash expenses are paid in the month incurred.
    • Variable selling and administrative costs are $2 per unit and are paid in month incurred
    • The unit sales price is $16 per unit
    • TT plans to buy a small parcel of land at the end of July for $15,000 with cash.
    • The cash balance of July 1 was $70,000.

c. What is budgeted income before taxes for July? $____________ Show supporting work. Check figure $19,000.

d. What are budgeted total cash collections for July? $________________ Show supporting work. Check figure $155,625.

e. What are budgeted payments to suppliers in July? $ ___________   Show supporting work. Check figure $88,755.

f. What is budgeted cash balance as of July 31? $__________ Show supporting work. Check figure $86,870.

g. What is the budgeted balance of Accounts Receivable on July 31? $___________   Show supporting work. Check figure $20,000

h. What is the budgeted balance of Accounts Payable on July 31? $_______________. Show supporting work. Check figure $27,990.

Solutions

Expert Solution


Related Solutions

The following information is from Harrelson Inc.'s, financial statements. Sales (all credit) were $37.80 million for...
The following information is from Harrelson Inc.'s, financial statements. Sales (all credit) were $37.80 million for last year.     Sales to total assets 2.10 times Total debt to total assets 30 % Current ratio 2.60 times Inventory turnover 5 times Average collection period 10 days Fixed asset turnover 5 times     Complete the balance sheet: (Use a 360-day year. Do not round intermediate calculations. Input your answers in millions rounded to 2 decimal places.) $ in millions $ in millions Cash...
The following information is from Andy's Pharmaceutical Inc.’s financial statements: Sales (all credit) $245,000 Total assets...
The following information is from Andy's Pharmaceutical Inc.’s financial statements: Sales (all credit) $245,000 Total assets turnover 0.80 times Total debt to total assets 30.83% Fixed asset turnover 1.1 times Current ratio 4.04 times Average collection period 29.68 days Inventory turnover 7.42 times Part A Using the above listed ratios and data, compute the balance of the following accounts. Assume all sales are on credit and a 360-day year. Round to the nearest dollar. [Hint: use ratio formulas to derive...
Puzzle Country, Inc. currently makes all sales on credit and offers no cash discount. The firm...
Puzzle Country, Inc. currently makes all sales on credit and offers no cash discount. The firm is considering a 3 percent cash discount for payment within 10 days. The firm's current average collection period is 90 days, sales are 2,500 puzzles per year, selling price is $20 per puzzle, variable cost per puzzle is $8,75, and the average cost per film is $10. The firm expects that the change in credit terms will result in a minor increase in sales...
Puzzle Country, Inc. currently makes all sales on credit and offers no cash discount. The firm...
Puzzle Country, Inc. currently makes all sales on credit and offers no cash discount. The firm is considering a 3 percent cash discount for payment within 10 days. The firm's current average collection period is 90 days, sales are 2,500 puzzles per year, selling price is $20 per puzzle, variable cost per puzzle is $8,75, and the average cost per film is $10. The firm expects that the change in credit terms will result in a minor increase in sales...
All of Pocast Corporation's sales are on account. Sixty percent of the credit sales are collected...
All of Pocast Corporation's sales are on account. Sixty percent of the credit sales are collected in the month of sale, 30% in the month following sale, and 10% in the second month following sale. The following are budgeted sales data for the company:   January February March April Total sales $ 700,000   $ 500,000   $ 400,000 $ 600,000   Cash receipts in April are expected to be: $530,000 $410,000 $460,000 $360,000
Hans was a sales representative at Enco, Inc. One morning he approached Norma, the production manager....
Hans was a sales representative at Enco, Inc. One morning he approached Norma, the production manager. “Hey, Norma,” he said. “I just got an order for 150 units. I had to promise speedy delivery to get the order.” Norma asked, “Well, how speedy did you promise them?” Hans said he promised two-day delivery. Norma replied, “Hans, you know we have to have at least two shifts to even get the production finished, without figuring in shipping time.” “What are you...
Elsee, Inc., has net sales of $16 million, and 75 percent of these are credit sales....
Elsee, Inc., has net sales of $16 million, and 75 percent of these are credit sales. Its cost of goods sold is 65 percent of annual net sales. The firm’s cash conversion cycle is 58.0 days. The inventory balance at the firm is $1,842,000, while its accounts payable balance is $2,387,000. What is the firm’s accounts receivable balance? (Round intermediate calculations to 1 decimal places, e.g. 15.1. and final answer to nearest whole dollar, e.g. 5,275.) The firm’s accounts receivables...
Elsee, Inc., has net sales of $15 million, and 75 percent of these are credit sales....
Elsee, Inc., has net sales of $15 million, and 75 percent of these are credit sales. Its cost of goods sold is 65 percent of annual net sales. The firm’s cash conversion cycle is 56.0 days. The inventory balance at the firm is $1,591,000, while its accounts payable balance is $2,068,000. What is the firm’s accounts receivable balance? (Round intermediate calculations to 1 decimal places, e.g. 15.1. and final answer to nearest whole dollar, e.g. 5,275.)
Complete the following payroll register for Thorndike Manufacturing Company. All workers receive time and one-half for...
Complete the following payroll register for Thorndike Manufacturing Company. All workers receive time and one-half for hours worked in excess of 40 hours per week. Compute Social Security using 6.2% and Medicare using 1.45%. Medical insurance and union dues deductions are shown in the payroll register. Use the wage bracket method to determine federal income tax. Total each column and verify the total net pay amount. Register Earnings Deductions Employee Name Allow. Status Hours Worked Pay Rate Regular Overtime Gross...
Q1. Recall Tourist-natives model. Every night, all 60 inhabitants of a tiny village visit one of...
Q1. Recall Tourist-natives model. Every night, all 60 inhabitants of a tiny village visit one of the village's two taverns (not necessarily the same tavern) and an average of 10 strangers do the same. Both the villagers and the strangers are willing to pay up to $3 for a drink, and no one ever buys more than one. But, whereas the stranger pick either of the taverns at random, the villagers compare prices and go where the drinks are cheapest....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT