Graham Potato Company has projected sales of $12,600 in September, $15,500 in October, $22,600 in November, and $18,600 in December. Of the company's sales, 25 percent are paid for by cash and 75 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 $19,000 and $11,500, 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 September October November December
Q: John Legglet is 42 years old, earns $4000 per week and is paid semi-monthly in the Province of…
A: Building a retirement income stream is one of the main advantages of CPP deductions for people. Your…
Q: The following information relates to labor for Sandhill Appliance Repair Shop. Repair-technicians'…
A: The sales price is a combination of the total cost and markup value and the price charged to its…
Q: On January 2, 2025, Indian River Groves began construction of a new citrus processing plant. The…
A: Weighted Average Accumulated ExpenditureThe weighted average accumulated expenditure refers to the…
Q: Beginning balances Additional contribution Net income Drawings Ending capital balances PURKERSON,…
A: A partnership is a business structure where two or more individuals share ownership and management…
Q: Assuming that all net sales figures are at retail and all cost of goods sold figures are at cost,…
A:
Q: Each of the three independent situations below describes a finance lease in which annual lease…
A: A lease is defined as a contractual agreement incorporated between two business entities where one…
Q: Total Value of Common Stocks (CS) Total Value of Preferred Stocks (PS) Total Value of Debt (D) O…
A: The objective of the question is to calculate the Weighted Average Cost of Capital (WACC). WACC is…
Q: Discuss with the class the types of statistical test you will use to interpret your survey results.…
A: The objective of this question is to identify the appropriate statistical tests that can be used to…
Q: The following information is available for the Murphy Manufacturing company for 2020. (Click the…
A: Direct material cost is the cost of raw material produced or purchased to produce the final…
Q: Suppose the following items were taken from the 2022 financial statements of Texas Instruments, Inc.…
A: The Balance Sheet is a financial statement that includes assets, liabilities and stockholder's…
Q: Current Attempt in Progress The controller is waiting on Bramble's budgeted cash disbursements so…
A: Cash disbursement schedule :— This budget is prepared to estimate the payment for direct materials…
Q: DATE TRANSACTIONS October 1 Shonna Pumphrey invested $90,000 cash in the business October 2 Paid…
A: General Guidelines:Journalize the Transactions:For each transaction, identify the accounts affected…
Q: On 1 January 20X3, Highmark Corp. had the following deferred tax balances: Deferred income tax asset…
A: Journal entries refers to the process of systematic documentation of the financial transactions of…
Q: On January 1, Year, 1, Henna Inc. purchased a building $800,000. The entire cost was recorded as a…
A: Retained earnings represent the earnings accumulated by the business over years of operation.…
Q: Which of the following is a method used to allocate overhead costs based on the activities that…
A: A) Job costingJob costing involves the accumulation of the costs of materials, labor, and overhead…
Q: Journalize the following transactions for Carla Vista Company. (a) (b) Purchased 5,900 units of raw…
A: A journal entry is a record of a transaction that a company or organization makes in its accounting…
Q: b. What is the amount of tax Jacob will owe on the income allocation if the income is qualified…
A: Qualified Business IncomeQualified Business Income (QBI) is defined as the net sum of qualified…
Q: Oriole Company makes three models of tasers. Information on the three products is given below. Sales…
A: Net Income refers to the amount an individual or business makes after deducting costs, allowances…
Q: In its income statement for the year ended December 31, 2025, Blossom Inc. reported the following…
A: Income Statement :— It is a financial statement that shows the profitability, total revenue and…
Q: hrd.4
A: A Journal Entry is just a summary of the debits and credits of the transaction that has been entered…
Q: During 2022 (its first year of operations) and 2023, Fieri Foods used the FIFO inventory costing…
A: The financial resilience of a corporation is bolstered by its retained earnings. A firm that has a…
Q: 4. Total lease payments 1,110,000 1,110,000 1,295,000 1,295,000
A: A lease is a contract that outlines the terms under which one party agrees to rent a property – in…
Q: Attempt in Progress The following information relates to Larkspur Ltd's inventory transactions…
A: FIFO is first in first out which means inventory bought first is sold first.Inventory means the…
Q: Required 1 Required 2 Required 3 Prepare a schedule of cost of goods sold. Froya Fabrikker A/S…
A: JOB ORDER COSTINGCompanies will choose a costing system that is appropriate to the nature of their…
Q: Blue Spruce Inc.'s $10 par value common stock is actively traded at a market price of $16 per share.…
A: Common stock is a type of tradeable assets, or security, that equates to ownership in company.Per…
Q: Required information (The following information applies to the questions displayed below] On…
A: True cash balance: The process of precisely estimating the real amount of cash accessible within the…
Q: Marco Company shows the following costs for three jobs worked on in April. Balances on March 31…
A: The overhead is applied to the production on the basis of predetermined overhead rate. The…
Q: Taylor, age 14, is claimed as a dependent by her parents. For 2023, she has the following income:…
A: Taxable income is the income after all deductions have been deducted. Every country has its tax…
Q: If the assets of a business increased $9,000 during a period of time and its liabilities increased…
A: ACCOUNTING EQUATIONAccounting Equation is a Financial Accounting Technique which represents the…
Q: [The following information applies to the questions displayed below.] Diego Company manufactures one…
A: Break even point is that level of sales where there is neither profit nor loss i.e. the company is…
Q: Resnick Inc. is considering a project that has the following cash flow data. What is the project's…
A: · It represents the period in which our initial investment will be returned by the project.·…
Q: What's Christie's gross income in 2021? Please explain.
A: Introduction:Gross income refers to the gross profit made by a corporation through the selling of…
Q: hrd.3
A: The bank reconciliation statement is prepared to adjust the balances of cash book and pass book with…
Q: Exercise 5-5 (Algo) Effect of inventory cost flow on ending inventory balance and gross margin LO…
A: First-in, first-out (FIFO) cost flow assumption -Under the FIFO Method, inventory purchased first is…
Q: Jasmine is single and turned 72 years old on October 1, 2023. Jasmine worked as a public historian…
A: Answer:- Earned income tax credit:- By lowering the amount of tax payable on a dollar for dollar…
Q: S Cala Manufacturing purchases land for $277,000 as part of its plans to build a new plant. The…
A: Journal Entry :— It is an act of recording transactions in books of account when transaction…
Q: In order for documentation to provide benefits to your company, you must know which form of…
A: Business Documentation: This involves recording and describing various aspects of a business,…
Q: Bonita Industries produces small lightweight camping trailers with rear kitchen facilities. The…
A: The question is based on the concept of Cost Accounting. Target Sales is the sales Required to…
Q: Record the transactions. The company uses the following accounts: Cash, Supplies, Equipment (for the…
A: journal entry is a record of a financial transaction in accounting. It is the first step in the…
Q: In January 2020, Marcus, Inc., acquired 20 percent of the outstanding common stock of Lily, Inc.,…
A: The question is based on the concept of financial accounting.
Q: Cost of a Fixed Asset Borges Inc. recently purchased land to use for the construction of its new…
A: Cost of an asset is the amount paid for an asset and for expenses incurred in putting the asset in…
Q: Exercise 1-11 (Algo) Cost Behavior; Contribution Format Income Statement [LO1-4, LO1-6] Harris…
A: Variable cost is the cost that changes with change in the activity of cost driver used. The variable…
Q: Required information [The following information applies to the questions displayed below.] Tennis…
A: Stockholder's Equity includes the amount contributed by shareholders in the form of common stock,…
Q: Required information [The following information applies to the questions displayed below.] Summary…
A: The ratio is the technique used by the prospective investor or an individual or strategist to read…
Q: On January 1, 2024, Rick's Pawn Shop leased a truck from Corey Motors for a six-year period with an…
A: A lease is defined as a contractual agreement incorporated between two business entities where one…
Q: Second Republic Bank is a lending company that operates in the Southeastern United States. Current…
A: In activity based costing all activities in the organization are identified and the cost of each…
Q: On January 1, 2025, Debra Smith signed an agreement, covering 5 years, to operate as a franchisee of…
A: Answer:- A method of selling products and services that is based on a relationship between the local…
Q: record each of the following events in the horizontal statement model after each event record the…
A: The year end adjustment entry is one of the primary tasks in performing the transactions and…
Q: Calculate the average unit cost for the inventory table shown below. Cost per Total cost Date of…
A: Weighted average method is one of useful method used for inventory management. Under this method,…
Q: 1 2 3 4 5 67 8 January 01 January 10 January 20 9 January 25 556 co 11 A 10 January 30 12 13 14 Date…
A: As per the FIFO (First in first out) method the inventory which comes first will out first, hence in…
Step by step
Solved in 4 steps
- A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000Cash 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 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.
- Barnstormer sells airplane accessories for $20 each. It expects sales of 120,000 units in quarter 1 and a 7% increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.Preparing a Direct Materials Purchases Budget Patrick Inc. makes industrial solvents sold in 5-gallon drums. Planned production in units for the first 3 months of the coming year is: Each drum requires 5.5 gallons of chemicals and one plastic drum. Company policy requires that ending inventories of raw materials for each month be 15% of the next months production needs. That policy was met for the ending inventory of December in the prior year. The cost of one gallon of chemicals is 2.00. The cost of one drum is 1.60. (Note: Round all unit amounts to the nearest unit. Round all dollar amounts to the nearest dollar.) Required: 1. Calculate the ending inventory of chemicals in gallons for December of the prior year and for January and February. What is the beginning inventory of chemicals for January? 2. Prepare a direct materials purchases budget for chemicals for the months of January and February. 3. Calculate the ending inventory of drums for December of the prior year and for January and February. 4. Prepare a direct materials purchases budget for drums for the months of January and February.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.
- Navigator sells GPS trackers for $50 each. It expects sales of 5,000 units in quarter 1 and a 5% increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.Coral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects sales of 15.9 million and cost of goods sold of 8.75 million. Advertising is a key part of Coral Seas business strategy, and total marketing expense for the year is budgeted at 2.8 million. Total administrative expenses are expected to be 675,000. Coral Seas has no interest expense. Income taxes are paid at the rate of 40 percent of operating income. Required: 1. Construct a budgeted income statement for Coral Seas Jewelry Company for the coming year. 2. What if Coral Seas had interest payments of 500,000 during the year? What effect would that have on operating income? On income before taxes? On net income?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.
- 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.Pasadena Candle Inc. budgeted production of 785,000 candles for January. Wax is required to produce a candle. Assume 10 ounces of wax is required for each candle. The estimated January 1 wax inventory is 16,000 pounds. The desired January 31 wax inventory is 12,500 pounds. If candle wax costs 1.24 per pound, determine the direct materials purchases budget for January.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