Required: 1. Prepare a schedule of expected cash collections for April, May, and June, and for the quarter in total. 2. Prepare the following for merchandise inventory: a. A merchandise purchases budget for April, May, and June. b. A schedule of expected cash disbursements for merchandise purchases for April, May, and June, and for the quarter in total. 3. Prepare a cash budget for April, May, and June as well as in total for the quarter.
Q: Natalie is thinking of repaying all amounts outstanding to her grandmother. Recall that Cookie…
A: 1. To calculate the interest payable that was accrued and recorded up to January 31, 2024, we need…
Q: A Parent Company owns 100 percent of its Subsidiary. During 2021, the Parent company reports net…
A: Parent company is that company which has right to control other company. The other company is known…
Q: What is the role of GAAP (Generally Accepted Accounting Principles) in the practice of accounting,…
A: The role of GAAP (Generally Accepted Accounting Principles) is to provide a standard set of rules…
Q: The following intangible items are incurred on Jan 1st. What is the maximum allowable deduction?…
A: There are two questions and as our protocol is to solve only one question. Given in the question:…
Q: Zebra Enterprises is in the business of manufacturing iron buckets. The firm is headquatered in…
A: Total working capital required = Raw materials + Work-in-progress + Finished goods + Credit allowed…
Q: A partial statement of financial position of Blossom Ltd. on December 31, 2022, showed the following…
A: Revaluation is defined as a process in which the assets are reported considering their fair values…
Q: Petra, Inc. has collected the following data. (There are no beginning inventories.): 410 units Units…
A: Since you have asked multiple question, we will solve the first question for you. If you want any…
Q: Write an Essay with a legal basis "A" bought the uncut, sugarcane crop of "B" still standing in the…
A: The case of "A" buying the uncut sugarcane crop of "B" raises a legal question of whether the…
Q: "Leased Liability":
A: Given Lease Term = 6 years Annual lease payment = $22740 Economic Life of asset =7 years Interest…
Q: On January 1, 2022, Indigo Corporation acquires a building at a cost of $120,000. The building is…
A: Commercial organizations used journal entries to record their financial transactions in their…
Q: In 2019, the average salary of petroleum engineers was $98,400. Predict what their salary will be in…
A: Time value of money is a financial concept which is used to calculate the value of money in present…
Q: TB TF Qu. 12 (Static) Ethics is defined as maximizing... Ethics is defined as maximizing personal…
A: Ethics refers to a set of principles or values that guide individual or group behavior in a moral…
Q: During the first month of operations ended July 31, Head Gear Inc. manufactured 25,600 hats, of…
A: NOTE: Since you have posted a question with multiple sub parts, we will provide the solution only to…
Q: The Comet Company, Inc. uses the perpetual inventory system. Their credit terms are 2/10, n/30. They…
A: The journal entries are prepared to record the transactions on regular basis. The customer is…
Q: Wildhorse Enterprises is a portable hot tub manufacturer. The company Anderson, the company's sales…
A: Sales Budget: It implies to a financial estimation or projection of the number of products or units…
Q: Compute cost of goods sold, assuming Sunland uses: (Round average cost per unit to 4 decimal places,…
A: Perpetual System LIFO Cost flow $195,700.00 Periodic System…
Q: Bank Reconciliation The following data were gathered to use in reconciling the bank account of…
A: Bank reconciliation is an important part of a company's internal control system. By regularly…
Q: Selected accounts from Westeros Company's adjusted trial balance for the year ended December 31…
A: Income Statement is one of the first financial statement prepared after the adjusted trial balance.…
Q: September 1. Year 1, Western Company loaned $36,600 cash to Eastern Company. The one year note…
A: Cash flow statement is one of financial statements. Cash flow statement includes three activities…
Q: b. What is the total amount of loans held by the bank? Use "total currency". c. What is this number…
A: A financial ratio known as the equity multiplier compares a company's total assets to its owners'…
Q: Teel Printing uses two measures of activity, press runs and book set-ups, in the cost formulas in…
A: Salaries and wage expense refer to the total amount of money that a company pays to its employees as…
Q: orporation is working on its direct labor budget for the next two Ich unit of output requires 0.41…
A: Labour cost is important component of the product. Labour cost increases with increasing in…
Q: A company's bank statement balance is $3,500 and shows a service charge of $24, interest earned of…
A: Answer:- Bank reconciliation:- An entity's bank account balance in its books of accounts is…
Q: Topic: Accounts, Debits and Credits 1. Analyze in detail: Introduction to the study of financial…
A: “Since you have posted multiple questions, we will provide the solution only to the first question…
Q: P1, P2, and P3 are partners in XYZ Inc. Their capital balances on Dec 31, Year 5, are $202,119 for…
A: In asset revaluation method, at the time of any Partner admission or going out, the total asset will…
Q: Problem 1 Meredith Company provided the following information: January 1,2020 December…
A: Allowance for doubtful accounts means where account receivables are not going to recover in full and…
Q: Wyatt Company acquired 35% interest in the voting stock of Staples Inc. for $550,000. During the…
A: Retained Earnings = Net income - Dividend
Q: On January 1, 2022, Blossom Company purchased the following two machines for use in its production…
A: Depreciation expense is the reduction in the value of asset due to its use, wear or tear. Journal…
Q: When the contribution margin is not sufficient to cover fixed expenses: Multiple Choice total profit…
A: The contribution margin is calculated as difference between sales and variable costs. The excess of…
Q: Which formula is used to determine the required purchases of raw materials for the direct materials…
A: Direct Material Budget :— This budget is prepared to estimate the raw material required to be…
Q: Standard cost of production in Dagoreti Ltd. is as follows: Time 2 hours per unit…
A: To calculate the labor variances, we first need to calculate the standard labor cost and the actual…
Q: Following are the individual financial statements for Gibson and Davis for the year ending December…
A: Consolidated financial statements includes income statement, balance sheet, cash flow statement.…
Q: Variable and absorption costing, explaining operating-income differences. Nascar Motors assembles…
A: Notes : Absorption costing: Absorption costing is compulsory under Generally Accepted Accounting…
Q: The inventory on hand at the end of 2019 for Reddall Company is valued at a cost of $95,000. The…
A: Ending inventory is the amount of inventory that an entity has, in hand at the end of the period. It…
Q: Weston Products manufactures an Industrial cleaning compound that goes through three processing…
A: Equivalent units means where the some goods remain incomplete at the end of process and we need to…
Q: 15. The Piano Man reported Net Income of $1,060,000 in 2024. Included as components of 2024 Net…
A: To calculate the net cash provided by operating activities, we need to start with net income and…
Q: A company's contribution margin ratio is 18% and its fixed monthly expenses are $49,000. If the…
A: Contribution Margin :— It is the difference between sales and variable cost. Operating income :—…
Q: outstanding stock) of Corporation for $500,000. Net income reported by Alamo for 2015 was $180,000.…
A: Companies buy the stock in other companies by doing investment. The income from investment depends…
Q: Blue Ridge Marketing Inc. manufactures two products, A and B. Presently, the company uses a single…
A: Factory overhead allocated per unit is calculated by multiplying the factory overhead rate with the…
Q: The production manager of Rordan Corporation has submitted the following quarterly production…
A: Notes : Management prepares budget in order to estimate future profit and loss of the business.…
Q: Ethical Issue: Moss Exports is having a bad year. Net Income is only $60,000. Also, two important…
A: Without reclassification:- Net Income = $60,000 Increase in Accounts Receivable = $80,000 Net cash…
Q: In 2019, Lee Electronics, a franchise of electronics stores located in small towns throughout the…
A: The details given in the question Units sold - 320 price per unit - $ 830 Repair cost - 2.5%
Q: Direct Materials, Direct Labor, and Factory Overhead Cost Variance Analysis Road Gripper Tire Co.…
A: Total direct material cost variance :— It is the difference between standard cost of direct material…
Q: Aylmer follows IFRS On January 1, 2015, Aylmer issued $400,000 12 % 10-year bonds. Interest is paid…
A: The bonds are the securities that the entity issue to borrow money. The bonds are long-term debt…
Q: The balance sheet for Munoz Corporation follows: Current assets Long-term assets (net) Total assets…
A: Financial ratios are very important in determining the liquidity and profitability and financial…
Q: A note dated June 1, 1995, calls for the payment of $85,000 in 6 years. On March 15, 1998, the note…
A: Present value refers to money received today being more valuable than the money will receive in…
Q: A variety of productschicken wings, drumsticks, thighs, and so on-are the result of a joint…
A: Incremental revenue :— It is the difference between revenue of two different alternatives.…
Q: Laura contributed $78,000 (including employer match) of pre-tax salary to her 401(k) plan over the…
A: The taxable portion is the portion of an individual's income, distribution, or transaction that is…
Q: Brunswick Home Remodelers (BHM) uses a job order cost system. The following debits (credits)…
A: Ending work in process = Beginning work in process + Total manufacturing costs - Ending work in…
Q: Chattanooga Development Company wants to evaluate replacing an older machine requiring significant…
A: Lets understand the basics. When there are two alternatives available then management try to choose…
Please help with 1-3 Thank you!!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 8 images
- Cash Budget The controller of Feinberg Company is gathering data to prepare the cash budget for July. He plans to develop the budget from the following information: a. Of all sales, 40% are cash sales. b. Of credit sales, 45% are collected within the month of sale. Half of the credit sales collected within the month receive a 2% cash discount (for accounts paid within 10 days). Thirty percent of credit sales are collected in the following month; remaining credit sales are collected the month thereafter. There are virtually no bad debts. c. Sales for the second two quarters of the year follow. (Note: The first 3 months are actual sales, and the last 3 months are estimated sales.) d. The company sells all that it produces each month. The cost of raw materials equals 26% of each sales dollar. The company requires a monthly ending inventory of raw materials equal to the coming months production requirements. Of raw materials purchases, 50% is paid for in the month of purchase. The remaining 50% is paid for in the following month. e. Wages total 105,000 each month and are paid in the month incurred. f. Budgeted monthly operating expenses total 376,000, of which 45,000 is depreciation and 6,000 is expiration of prepaid insurance (the annual premium of 72,000 is paid on January 1). g. Dividends of 130,000, declared on June 30, will be paid on July 15. h. Old equipment will be sold for 25,200 on July 4. i. On July 13, new equipment will be purchased for 173,000. j. The company maintains a minimum cash balance of 20,000. k. The cash balance on July 1 is 27,000. Required: Prepare a cash budget for July. Give a supporting schedule that details the cash collections from sales.Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent 12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of June 1 include cash of 42,000, marketable securities of 25,000, and accounts receivable of 198,000 (150,000 from May sales and 48,000 from April sales). Sales on account in April and May were 120,000 and 150,000, respectively. Current liabilities as of June 1 include 13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 24,000 will be made in July. Mercury Shoes regular quarterly dividend of 15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of 40,000. Instructions Prepare a monthly cash budget and supporting schedules for June, July, and August. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?
- CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2014 and 2015: May 2014 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360.000 November 360,000 December 90,000 January 2015 180.000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2014 90,000 June 90,000 July 126,000 August 882.000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses arc S2,700 a month. Income tax payments of 63,000 arc due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2014. b. Prepare monthly estimates of the required financing or excess funds that is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 130 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2015 and 2016: May 2015 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2016 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2015 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2015. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1 30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017. May 2016 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale. 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2016 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depredation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2016. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if ail financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
- Budgeted income statement and supporting budgets The budget director of Jupiter Helmets Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for May: Prepare a cost of goods sold budget for May. Work in process at the beginning of May is estimated to be $4200. and work in process at the end of May is desired to be $3800.A. Discuss the purpose of the cash budget. B. If the cash for the first quarter of the fiscal year indicates excess cash at the end of each of the first two months, how might the excess cash be used?Relevant data from the Poster Companys operating budgets are: Additional data: Capital assets were sold in January for $10,000 and $4,500 in May. Dividends of $4,500 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year