The ending cash balance for 2009 was $28,000. Sales $140,000 160,000 2009-Actual November December 2010-Budgeted January February March $ 90,000 80,000 100,000 Purchases $ 80,000 100,000 $ 90,000 100,000 80,000 Prepare a cash budget and determine the projected ending cash balances for the first three months of 2010.
Q: Assume a company had net operating income of $300,000, sales of $1,500,000, average operating assets…
A: Residual income :— It is the difference between net operating income of the company and the amount…
Q: The following account balances are for the Agee Company as of January 1, 2020, and December 31,…
A: The rate at which one country’s currency can be converted into another country’s currency referred…
Q: ! Required information CP9-1 (Algo) Computing Acquisition Cost and Recording Depreciation under…
A: Depreciation Expense -Depreciation Expenses are the expense incurred on the wear and tear of the…
Q: S16-9 On January 6, 2023, Ling Corp. paid $5,000,000 for its 40 percent investment in True World…
A: To account for investments in other companies, there are generally two methods: the equity method…
Q: Rita owns a sole proprietorship in which she works as a management consultant. She maintains an…
A: Tier 1 expenses are the real property taxes and mortgage interest that are allocated to the home…
Q: Franco and Jason share income and losses in a 2:1 (2/3 to Franco and 1/3 to Jason) ratio after…
A: The objective of the question is to determine the increase in Jason's capital account after the…
Q: Singer and McMann are partners in a business. Singer's original capital was $40,000 and McMann's was…
A: The objective of the question is to calculate Singer's share of the income (loss) for the year when…
Q: Water Cruises rents canoes and other water crafts to campers and hikers. On February 15, 2021, Water…
A: Payroll register is a tool that contains information regarding wages like gross pay, income tax,…
Q: Prior to installing a JIT system, Clarendon Company used machine hours to assign maintenance costs…
A: The objective of the question is to calculate the maintenance cost per roll of 6-inch insulation…
Q: Volata Company began operations on January 1, 2019. In the second quarter of 2020, it adopted the…
A: The amount that remains after expenses, benefits, and taxes are subtracted from the earnings of a…
Q: Marigold's AGI was $85,000 in 2022. She incurred the following expenses: Property taxes on primary…
A: The objective of the question is to calculate the amount of expenses Marigold can deduct as an…
Q: Question Content Area The following units are available for sale during the year: Jan. 1 Beginning…
A: We are tasked with calculating the value of the ending inventory and the cost of goods sold (COGS)…
Q: Horizontal Analysis The comparative accounts payable and long-term debt balances for a company…
A: Horizontal analysis of balance sheet is a analysis of balance sheet in which balance sheet amount of…
Q: Siham and Dalia are partners with capital balances of $60,000 and $40,000, respectively. Profits and…
A: Partnership:A partnership is an arrangement between two or more people whereby they agree to manage…
Q: River Signorini works for New & Old Apparel, which pays employees on a semimonthly basis. River's…
A: Social security tax: Employee's pension and benefit for disability are secured through the social…
Q: Temporary Differences 1. Excess of tax depreciation over book depreciation 2. Accrual, for book…
A: A financial statement that depicts an organization's financial situation at a certain period in…
Q: A company prepares its financial statements according to International Financial Reporting…
A: The objective of the question is to determine the amount of expenditures that would be expensed in…
Q: Based on a predicted level of production and sales of 22,000 units, a company anticipates total…
A: Contribution margin is the difference between total sales revenue and variable costs, representing…
Q: In January, 2023, Demba Corporation purchased a mineral mine for $3,400,000 with removable ore…
A: Natural resources deplete you over time in the same way that material goods do due to wear and tear.…
Q: 3
A: The objective of the question is to calculate the depreciation expense for the year 2024 using the…
Q: Ecru Company has identified five industry segments: plastics, metals, lumber, paper, and finance. It…
A: A division of a company that produces its own income and develops its own product line or products…
Q: Metlock Company uses a periodic inventory system. For April, when the company sold 650 units, the…
A: FIFO: FIFO stands for First-In, First-Out. In this method inventory purchased first will be sell…
Q: Required information. [The following information applies to the questions displayed below.) In…
A: In the statement of cash flows after tax which shows how a company's cash position has changed over…
Q: Exercise 13-7 (Algo) Sell or Process Further Decisions [LO13-7] Dorsey Company manufactures three…
A: Incremental Analysis :— This analysis shows the comparison between two different alternatives. A…
Q: Beacon Corporation issued a 6 percent stock dividend on 28,500 shares of its $7 par common stock. At…
A: Stock dividend is the amount of dividend paid to the shareholders in the form of shares rather than…
Q: The comparative statement of financial position for Wildhorse Corporation shows the following…
A: Lets understand the basics.Cashflow statement gets divided into three type of activities which…
Q: Quality data gathering, analysis, and reporting et cost of spoilage Re-entering data because of…
A: External failure costs include a wide range of monetary consequences, such as lawsuits, product…
Q: Problem 9-5A (Algo) Part 2 2. If the market interest rate is 7%, the bonds will issue at $357,290.…
A: The bond is a type of financial instrument issued by companies or governments in order to raise…
Q: In preparation for developing its statement of cash flows for the year ended December 31, 2024,…
A: Explanation:The cash flows statement is one of the Financial statement, it shows the cash inflows…
Q: On October 15, 2025, Oil Products Co. purchased 4,000 barrels of fuel oil with a cost of $240,000…
A: Income statement:An income statement stands for the statement that shows profits and loss of the…
Q: Newton Corp. has a contract to construct a $5,000,000 cruise ship at an estimated cost of…
A: Accounts receivable The term "account receivable” means the payment is yet to be made for the work…
Q: Pauley Company needs to determine a markup for a new product-Pauley expects to sell 15,000 units and…
A: Variable cost :— It is the cost that changes with change in activity of cost driver. Variable cost…
Q: The OXO Inc. Manufactures its product in two successive departments, namely A and B. During the…
A: The production cost report may be prepared using the FIFO method or weighted average method. The…
Q: The payroll register should be retained for the same amount of time as other payroll documents. True…
A: Payroll records includes the documents pertaining to employee's pay that a company needs to maintain…
Q: Fortes Incorporated has provided the following data concerning one of the products in its standard…
A: Variance analysis is the difference between the standard performance and the actual performance,…
Q: Flounder Limited has 55,500 common shares outstanding, with an average issue price per share of $6.…
A: In case of reacquisition of shares which is also known as share buyback or stock repurchase, occurs…
Q: needed 527,000 0 470,000 0 41
A: A purchase budget shows the value of goods a company must purchase to achieve its sale revenue.
Q: For financial reporting, Kumas Poultry Farms has used the declining- balance method of depreciation…
A: A change in depreciation method is an example of a change in accounting estimate. The treatment of…
Q: Andretti Company has a single product called a Dak. The company normally produces and sells 86,000…
A: “Since you have posted multiple questions, we will provide the solution and only to the first…
Q: Required information [The following information applies to the questions displayed below.] Jorgansen…
A: Absorption costing method is a method of costing in which product cost is calculated by adding…
Q: On July 10, 2023, Ariff places in service a new SUV that cost $70,000 and weighed 6,300 pounds. The…
A: If a sport utility vehicle (SUV) is exempt from the annual “luxury car” depreciation caps, the…
Q: Problem 15-6 (Algo) (LO 15-4) A partnership is considering possible liquidation because one of the…
A: Partnership : Arrangement between two or more people whereby they agree to manage business…
Q: Revenue Expenses: Answer is complete but not entirely correct. Quilcene Oysteria Revenue and…
A: Revenue and spending variance :— It is the difference between actual results and flexible budget.…
Q: From the following information, calculate the payroll tax expense for Gray Company for the payroll…
A: Since cumulative payroll for the current payroll period is less than $127,700, all payroll for…
Q: Patty and Paul are partners who share income in the ratio of 3:2 (3/5 to Patty and 2/5 to Paul).…
A: The objective of the question is to find out the capital balance of Paul after the revenue and…
Q: Following are sales and other operating data for the three products made and sold by Marine Marine…
A: Operating earnings are a type of financial measurement that shows how much money a business makes…
Q: Bramble Corp. issued $318,000, 9%, 15-year bonds on December 31, 2021, for $298,920. Interest is…
A: Journal Entry :— It is an act of recording transactions in books of account when transaction…
Q: Puget Sound Divers provides diving services, such as underwater ship repairs, to its clients. The…
A: Variable cost is the cost that changes with change in the activity of cost driver used. The variable…
Q: On January 1, Ivanhoe Corporation had 62,400 shares of no-par common stock issued and outstanding.…
A: The accounting equation states that assets are equal to the sum of the liabilities and equity. The…
Q: Cash collections Cash payments: Purchases of direct materials Apr $43,000 OA. $56,000 OB. $54,900 O…
A: The projected cash balance is calculated with the help of cash budget. The cash budget can be…
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Do not give image format
Step by step
Solved in 4 steps with 2 images
- Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?Alard Manufacturing Company has a billing department staffed by four billing clerks. Each clerk is paid 32,000 per year and is able to process 8,000 bills. Last year, 27,360 bills were processed by the four agents. Calculate the unused capacity in terms of number of bills. a. 27,360 b. 4,640 c. 8,000 d. 32,000
- Markson and Sons leases a copy machine with terms that include a fixed fee each month plus acharge for each copy made. Markson made 9,000 copies and paid a total of $480 in January. In April, they paid $320 for 5,000 copies. What is the variable cost per copy if Markson uses the high-low method to analyze costs?Olin Company manufactures and distributes carpentry tools. Production of the tools is in the mature portion of the product life cycle. Olin has a sales force of 20. Salespeople are paid a commission of 7 percent of sales, plus expenses of 35 per day for days spent on the road away from home, plus 0.50 per mile. They deliver products in addition to making the sales, and each salesperson is required to own a truck suitable for making deliveries. For the coming quarter, Olin estimates the following: On average, a salesperson travels 6,000 miles per quarter and spends 38 days on the road. The fixed marketing and administrative expenses total 400,000 per quarter. Required: 1. Prepare an income statement for Olin Company for the next quarter. 2. Suppose that a large hardware chain, MegaHardware, Inc., wants Olin Company to produce its new SuperTool line. This would require Olin Company to sell 80 percent of total output to the chain. The tools will be imprinted with the SuperTool brand, requiring Olin to purchase new equipment, use somewhat different materials, and reconfigure the production line. Olins industrial engineers estimate that cost of goods sold for the SuperTool line would increase by 15 percent. No sales commission would be incurred, and MegaHardware would link Olin to its EDI system. This would require an annual cost of 100,000 on the part of Olin. MegaHardware would pay shipping. As a result, the sales force would shrink by 80 percent. Should Olin accept MegaHardwares offer? Support your answer with appropriate calculations.Betta Jets, a toy wholesaler, is hoping to expand into manufacturing its own products. The business owners have provided you with the following information: All sales are on credit. The company collects 70% in the month following the sale and 30% two months following the sale. All purchases of stock are paid for one month after the purchase. Equipment costing $250,000 is expected to be acquired and paid for in July. The selling and distribution expenses are $48 000 each month. Administrative expenses are $42 000 per month. This includes $5 000 of depreciation expense. Selling Expenses and Administrative Expenses are paid in the month they are incurred. The cash balance on 1 July 2022 is $28 000. The following sales and purchases data in 2022 have been compiled for the preparation of the budget: April May June July $ $ $ $ Purchases 300 000 360 000 340 000 400 000 Sales 800 000 860 000 840 000 880 000 REQUIRED: Prepare…
- 75 Slabs International is in the building construction business. In 2019, it is expected that 40 percent of a month's sales will be collected in cash, with the balance being collected the lowing month. Of the purchases, 50 percent are paid the following month, 30 percent are patd two months, and the remaining 20 percent are paid during the month of purchase. The sales rce receives P2,000 a month base pay plus a 2 percent commission. Labor expenses are pected to be P4,000 a month. Other operating expenses are expected to run about P2,000 a onth, including P500 for depreciation. The ending cash balance for 2018 was P4,500. alse lo rinon Sales dino Purchases belio 02018 Actual P80,000 November December om 2019 Budgeted January February March P70,000 Hino beoc 90,000 inuo 80,000 allon vs eslse leloT 70,000 60,000 oeib rias 50,000 70,000 90,000 30,000 ructions: 1 Prepare a cash budget and determine the projected ending cash balances for the first three months of 2019. 2 Determine the months…AB has generated $150,000 in sales during the past few months and expected the level of sales willcontinue for the next year. Based on the firm’s past experience, 30% of the sales will be collected in the month of the sale and these customers will take the 4% cash discount offered for early payment. 70% of the remaining sales will becollected one month after the sale. AB normally purchases and pays for raw materials which is 70% of sales, in the same month the finished goods are sold. Wages of AB employees represents 15% of sales and monthly rent is $10,000. At present, the firm has no cash but its target balance is $6,000. ConstructAB'S cash budget for the next three months.(b) Nazmi Shah Sdn Bhd wishes to expand its business by opening an additional two more stores and needs to apply a bank loan. Therefore, there is needed to prepare an acceptable three-month financial plan for January until March. The following are sales and purchase information: Sales (RM) Purchase (RM) 160,000 150,000 Month November December January February March 235,000 255,000 210,000 280,000 110,000 150,000 240,000 190,000 40 percent of the sales incurred are cash sales, while the balance are credit sales and will be collected equally for the second and third month after the sales. Nazmi Shah pays 50 percent of its purchase immediately and the balance will be paid in the month after purchases.
- Copley Paper Supply expects to have the sales and expenses shown for May, June, and July. The company expects to receive 70% of the sales in the month of the sale, 25% thefollowing month, and 5% to be uncollectible. The company's policy to pay manufacturing cost includes 65% in the month incurred and 35% the following month. All other costs are paid in the month incurred. In addition, the company must pay an income tax payment in July, which the company estimates will be 10% of total sales for the quarter. The company will also receive interest revenue of $1,200 in June. May $102,500 $100,000 $105,200 $107,100 Аpril June July Sales Manufacturing costs 30,000 34,500 38,000 36,500 Selling expenses Administrative expenses 14,900 14,900 22,500 15,000 20,000 20,000 22,500 25,000 Prepare the cash budget for the three months if the cash balance as of May 1, 2015, totaled $102,000. The company requires a $100,000 minimum cash balance.Lakeside Components wishes to purchase parts in one month for sale in the next. On June 1, the company has 9,000 parts in stock, although sales for June are estimated to total 11,400 parts. Total sales of parts are expected to be 8,800 in July and 13,900 in August. Parts are purchased at a wholesale price of $15. The supplier has a financing arrangement by which Lakeside Components pays 70 percent of the purchase price in the month when the parts are delivered and 30 percent in the following month. Lakeside purchased 15,000 parts in May. Required:a. Estimate purchases (in units) for June and July.b. Estimate the cash required to make purchases in June and July. Required A Required B Estimate purchases (in units) for June and July. June July Merchandise to be purchased in units Month of Payment Total June not attempted JulyGyles Ltd. Expects sales for January and February to be $50,000 and $35,000 respectively. The collection pattern has been 30% of sales is collected in the month of sale and the other 70% collected in the month after sale. In addition, Gyles expects to sell property worth $3,000 in February. Gyles also expects to purchase materials of $15,000 and $8,750 in January and February respectively. Gyles pays 80% of the cost of materials purchased in the month of purchase and the other 20% in the month following the purchase. Direct labour payroll will be $12,500 and other expenditures are budgeted at $24,900. The other expenditures included depreciation of $10,000. If not told otherwise, payments are assumed to be made in the month incurred. On February 1, Gyles Ltd. Had a cash account balance of $1,230. The total cash available for the month of February is: a)$1,230 b)$45,500 c)$49,730 d)$85,000