91,550 feet? feetJune 30September 30e. Gilden costs $0.60 per foot. One-half of a month's purchases of Gilden is paid for in the month of purchase; the remainder is paidfor in the following month. The accounts payable on July 1 for purchases of Gilden during June will be $49,290.Required:1. Calculate the estimated sales, by month and in total, for the third quarter.2. Calculate the expected cash collections, by month and in total, for the third quarter.3. Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October.4. Calculate the quantity of Gilden (in feet) that needs to be purchased by month and in total, for the third quarter.5. Calculate the cost of the raw material (Gilden) purchases by month and in total, for the third quarter.6. Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter.Complete this question by entering your answers in the tabs below.Req 1Req 2Req 3Reg 4 and 5Req 6Calculate the estimated sales, by month and in total, for the third quarter.JulyAugustSeptemberQuarterBudgeted salesReg 1Req 2 > Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled thefollowing information to assist in the budget preparation:a. The Marketing Department has estimated sales as follows for the remainder of the year (in units):JulyAugustSeptember38,50087,00056,000October28,50015,00015,500NovemberDecemberThe selling price of the beach umbrellas is $14 per unit.b. All sales are on account. Based on past experience, sales are collected in the following pattern:30% in the month of sale65% in the month following sale5% uncollectibleSales for June totaled $504,000.C. The company maintains finished goods inventories equal to 15% of the following month's sales. This requirement will be met at theend of June.d. Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires thatthe ending inventory of Gilden be equal to 50% of the following month's production needs. The inventory of Gilden on hand at thebeginning and end of the quarter will be:

Required: 1. Calculate the estimated sales, by month and in total, for the third quarter. 2. Calculate the expected cash collections, by month and in total, for the third quarter. 3. Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October.

Required: 1. Calculate the estimated sales, by month and in total, for the third quarter. 2. Calculate the expected cash collections, by month and in total, for the third quarter. 3. Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Answer all the requirements….
Management wants to know if there will be a need for short-term financing in February. Essential information is as follows: Estimated sales for January and February are $1.1 million and $750,000, respectively. Sixty percent of sales are for cash and 40 percent are credit sales that are collected the next month. Cash disbursements that vary with sales are 35 percent of sales. Fixed operating disbursements are $400,000 a month. Depreciation expense is $50,000 a month. A tax payment of $70,000 is due in January. A bond payment of $250,000 is owed and will be due in February. The cash balance at the beginning of January is $12,000. Management seeks a minimum cash balance of $9,000. December credit sales were $110,000. Round your answers to the nearest dollar. Use a minus sign to enter shortage of cash, if any. January February Excess (shortage) of cash $ $ The firm need short-term funds in February.
You are preparing a cash budget for the month of September. how would you use information about sales in the preceding July?
Here is a forecast of sales by National Bromide for the first four months of 2019 (figures in $ thousands): Month 1 Month 2 Month 3 Month 4 Cash sales 17 26 20 16 Sales on credit 120 140 110 90 On the average 52% of credit sales are paid for in the current month, 32% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? (Do not round intermediate calculations. Enter your answers in thousands rounded to the nearest whole number.)
Can I get the answer for requirement A in the attached picture
Evergreen Furniture, a retailing company, is preparing the cash budget for August. The following inventory information available: Estimated payments in August for purchases in August Estimated purchases for August Estimated cost of goods sold for August Estimated payments in August for purchases in July Estimated payments in August for purchases prior to July Inventories at beginning of August Required: What are the estimated cash disbursements in August? Estimated cash disbursements 70% $ 2,444,000 2,600,000 696,000 176,000 674,000
Suppose that the Sales in December 2019 were 41,498. The sales are expected to grow by 5% in January 2020, by 10% in February 2020, and by 15% in March 2020. After that, the sales are expected to grow by 9%. The company's cash collection is as follows: 24% is collected in the same month, 47% is collected in the next month, and the remainder in the following month. What is the cash collection for July, 2020?
Can someone help me with 2A, 2B, and 3 please?
Please help with question 1 and 2. Both the images are of the same continuing question
Hernandez Company expects credit sales for January to be $58,000. Cash sales are expected to be $38,000. The company expects credit and cash sales to increase 10% for the month of February. Credit sales are collected in the month following the month in which sales are made. Based on this information, the amount of cash collections in February would be:
31
Prepare schedules for cash receipts and cash payments, and determine the ending balances for the relevant balance sheet accounts. E10.30 (LO 4, 5) Service Environmental Landscaping Inc. is preparing its budget for the first quarter of 2022. The next step is to prepare a cash receipts schedule and a cash payments schedule. The following information has been collected: 1. Clients usually pay 50% of their fee in the month when the service is provided, 40% the next month, and 10% in the second month after receiving the service. 2. Actual service revenues for 2021 and expected service revenues for 2022 are as follows: November 2021, $90,000; December 2021, $70,000; January 2022, $110,000; February 2022, $120,000; and March 2022, $130,000. 3. The company pays for purchases of landscaping supplies (direct materials) 60% in the month of purchase and 40% the following month. Actual purchases for 2021 and expected purchases for 2022 are: December 2021, $14,000; January 2022, $13,000; February…