Coyote Loco is a manufacturer of salsa. The follow historical collection pattern for its credit sales are as follows: 70% collected in month of sale 15% collected in first month after sale 10% collected in second month after sale 4% collected in third month after sale 1% uncollectible. The sales on account have been budgeted for the last seven months as: June – $122,500 July – 150,000 August – 175,000 Sept – 200,000 Oct – 225,000 Nov – 250,000 Dec – 212,500 1. Compute estimated cash collections during October from credit sales. 2. Compute the estimated total cash collections during the fourth quarter from sales made on account during the fourth quarter. 3. Construct an Excel spreadsheet to solve both of the preceding requirements. Show how the solution will change if the following information changes: sales in June and July were $100,000 and $130,000 respectively. 2… Sophisticates, Inc., a distributor of jewelry throughout California, is in the process of assembling a cash budget for the first quarter of 20×1. The following information has been extracted from the company’s accounting records: • All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 35 percent are collected in the following month. Uncollectibles amounting to 5 percent of sales are anticipated, and management believes that only 20 percent of the accounts outstanding on December 31, 20×0, will be recovered and that the recovery will be in January 20×1. • Seventy percent of the merchandise purchases are paid for in the month of purchase; the remaining 30 percent are paid for in the month after acquisition. • The December 31, 20×0, balance sheet disclosed the following selected figures: cash, $60,000; accounts receivable, $165,000; and accounts payable, $66,000. • Sophisticates, Inc., maintains a $60,000 minimum cash balance at all times. Financing is available (and retired) in $1,000 multiples at an 8 percent interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid at that time. Additional data: JanuaryFebruary March Sales revenue …………………………………………$450,000 $540,000 $555,000 Merchandise purchases …………………………… 270,000300,000420,000 Cash operating costs ………………………………. 93,000 72,000 135,000 Proceeds from sale of equipment……………….. — — 15,000 Required: 1. Prepare a schedule that discloses the firm’s total cash collections for January through March. 2. Prepare a schedule that discloses the firm’s total cash disbursements for January through March. 3. Prepare a schedule that discloses the firm’s cash needs, if any, for January through March. The schedule should present the following information in the order cited: Beginning cash balance, total receipts (from requirement 1), total payments (from requirement 2), the cash excess (deficiency) before financing , borrowing needed to maintain minimum balance, loan principal repaid, loan interest paid, and ending cash balance. 3. Concord Farms produces items made from local farm products that are distributed to supermarkets. For many years, Concord’s products have had strong regional sales on the basis of brand recognition; however, other companies have begun marketing similar products in the area, and price competition has become increasingly important. Doug Gilbert, the company’s controller, is planning to implement a standard cost system for Concord and has gathered considerable information from his co-workers on production and material requirements for Concord’s products. Gilbert believes that the use of standard costing will allow Concord to improve cost control and make better pricing decisions. Concord’s cost popular product is strawberry jam. The jam is produced in 10-gallon batches, and each batch requires six quarts of good strawberries. The fresh strawberries are sorted by hand before entering the production process. Because of imperfections in the strawberries and normal spoilage, one quart of berries is discarded for every four quarts of acceptable berries. Three minutes is the standard direct-labor time for sorting required to obtain one quart of acceptable strawberries. The acceptable strawberries are then blended with the other ingredients. Blending requires 12 minutes of direct-labor time per batch. After blending, the jam is packaged in quart containers. Gilbert has gathered the following information from Joe Adams, Concord’s cost accountant. • Concord purchases strawberries at a cost of $1.60 per quart. All other ingredients cost a total of $0.90 per gallon. • Direct labor is paid at the rate of $18.00 per hour. • The total cost of material and labor required to package the jam is $0.76 per quart. Adams has a friend who owns a strawberry farm that has been losing money in recent years. Because of good crops, there has been an oversupply of strawberries, and prices have dropped to $1.00 per quart. Adams has arranged for Concord to purchase strawberries from his friend and hopes that $1.60 per quart will help his friend’s farm become profitable again. Required: 1. Develop the standard cost for the direct-cost components of a 10-gallon batch of strawberry jam. The standard cost should identify the following amounts for each direct-cost component of a batch of strawberry jam: (a) standard quantity, (b) standard price or rate, and (c) standard cost per batch. 2. Citing the specific ethical standards of competence, confidentiality, integrity, and credibility for management accountants (see “IMA Statement of Ethical Professional Practice” in Chapter 1), explain why Joe Adams’s behavior regarding the cost information provided to Doug Gilbert is unethical. 3. As part of the implementation of a standard-costing system at Concord Farms, Doug Gilbert plans to train those responsible for maintaining the standards in the use of variance analysis. Gilbert is particularly concerned with the causes of unfavorable variances. Discuss the possible causes of the following unfavorable variances and identify the individual(s) who should be held responsible: (a) direct-material purchase price variance and (b) direct-labor efficiency variance.
They have a magnificent team. These people are always kind and willing to listen to your concerns or issues. Better yet, your assignment is always ready before the time, they usually send you a draft to double-check before they finalize your paper.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more