Watt's Lighting Stores made the following sales projection for the next six months. All sales are credit sales.MarchAprilMayJuneJulyAugust$ 42,00048,00037,00046,00054,00056,000Sales in January and February were $45,000 and $44,000, respectively.Experience has shown that of total sales, 10 percent are uncollectible, 30 percent are collected in the month of sale, 40 percent arecollected in the following month, and 20 percent are collected two months after sale.Prepare a monthly cash receipts schedule for the firm for March through August.Credit salesCollections:In month of saleOne month after saleWatt's Lighting StoresCash Receipts ScheduleJanuaryFebruaryMarchAprilMayJuneJulyAugustTwo months after sale$0 $0 $0 $0 $0 $0Total cash receipts

Watt's Lighting StoresCash Receipts ScheduleMarch - August MonthCredit Sales Collections from Prior…

Answered: Watt's Lighting Stores made the…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

The production planner of a company forecasts the sales over the next six months as 180, 220 , 210, 190, 170, and 210 units, respectively. The beginning inventory is 100 units and the last monthly production level was 130 units. The unit costs are given as follows: Inventory holding cost is 90 TL per unit per month; production cost is 1150 TL per unit; production level increasing cost is 300 TL per unit; and production level decreasing cost is 400 TL per unit. The planner decides to use level strategy, where the monthly production level is determined equal to the average of net demand. What is the total cost (in TL) of the resulting plan? O a 1,246,350 O b. 1,347,450 O c. 1,412,850 O d. 1,391,100 O e. 1,278,600
Bortle Manufacturing Group estimates that sales for the coming year will be 576,000 units. Company policy is to maintain a finished goods inventory of one and one-half month's unit sales. Beginning inventory is 75,000 units. Assume sales occur uniformly throughout the year. Required: Estimate the production level for the coming year for Bortle to meet these objectives Production in units =
Hunt Company's sales, based on past experience, are 30% cash and 70% credit. Credit sales are typically collected as follows: 40% in the month of sale, 50% in the month after the sale, and 10% in the second month following month of sale. On December 31, the accounts receivable balance is $69,000, of which $24,000 is from November sales. Total sales for January and February are budgeted to be $110,000 and $130,000, respectively. What are Hunt Company's budgeted cash receipts for January? Multiple Choice $79,500. $92,500. $95,800. $112,500. $125,300.
Star Company was organized on August 1 of the current year. Projected sales for the next three months are as follows: August $250,000 September 200,000 October 275,000 The company expects to sell 50% of its merchandise for cash. Of the sales on credit, 30% are expected to be collected in the month of the sale and the remainder in the following month. What is Star Company expected cash collection for September?
Treasure Service anticipates the following sales revenue over a five-month period: Its collection history indicates that credit sales are collected as follows: E (Click the icon to view the sales data.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Done
Graham Potato Company has projected sales of $12,000 in September, $15,000 in October, $22,000 in November, and $18,000 in December. Of the company's sales, 30 percent are paid for by cash and 70 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December. Also assume Graham's cash payments for November and December are $18,500 and $11,000, respectively. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. Graham Potato Company Cash Receipts Schedule Sales Credit sales Cash sales One month after sale Two months after sale Total cash receipts September October November December
Avery Company projects the following sales for the first three months of the year: $13,500 in January; $15,900 in February; and $15,800 in March. The company expects 80% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Prepare a schedule of cash receipts for Avery for January, February, and March. What is the balance in Accounts Receivable on March 31?
Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter which has been provided in the below table. Following Year Quarter in Coming Year Second $362 Third $338 Fourth $386 First First Quarter Sales forecast $374 $386 Paymore's labor and administrative expenses are $67 per quarter and interest on long-term debt is $42 per quarter. Paymore's cash balance at the start of the first quarter is $40 and its minimum acceptable cash balance is $30. Assume that Paymore can borrow up to $338 from a line of credit at an interest rate of 2% per quarter. On average, one-third of sales are collected in the quarter that they are sold, and two-thirds are collected in the following quarter. Assume that sales in the last quarter of the previous year were $338. On average, two-thirds of purchases are paid for in the quarter that they are purchased, and one-third are paid in the following quarter. Prepare a short-term financing plan using the above table. (Leave no…
How much is the company's expected cash collections in the month of May?
Pardee Company makes 30% of its sales for cash and 70% on account. 60% of the account sales are collected in the month of sale, 25% in the month following sale, and 12% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current year: Month 1 2 3 4 Total sales $78,000 $80,000 $68,000 $48,000 Total cash receipts in Month 4 will be: A. 38,780 B.68,000 C.53,180 D.50,600
Millen’s managers have made the following additional assumptions and estimates: Estimated sales for July and August are $310,000 and $330,000, respectively. Each month’s sales are 20% cash sales and 80% credit sales. Each month’s credit sales are collected 30% in the month of sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. Each month’s ending inventory must equal 20% of the cost of next month’s sales. The cost of goods sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July. Monthly selling and administrative expenses are always $70,000. Each month $10,000 of this total amount is depreciation expense and the remaining $60,000 relates to expenses that are paid in the month they are incurred. The company does not plan to buy or sell any plant and equipment…
A hotel has 120 rooms. It has 86% occupancy and an average daily rate (ADR) of $125 in April and is forecasting 88% occupancy and an average daily rate (ADR) of $130 for May. Hotel's collection pattern for sales is as follows: 15% of sales are cash and the remaining 85% are invoiced to tour groups. For credit sales, 60% is collected in the month of sale and 40% is collected in the month following the sale. How much is the hotel's forecasted Revenue in May? O a. $452,865 O b. $452,658 Oc $425,856 O d. $425,568

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS