75Slabs International is in the building construction business. In 2019, it is expected that 40percent of a month's sales will be collected in cash, with the balance being collected thelowing month. Of the purchases, 50 percent are paid the following month, 30 percent are patdtwo months, and the remaining 20 percent are paid during the month of purchase. The salesrce receives P2,000 a month base pay plus a 2 percent commission. Labor expenses arepected to be P4,000 a month. Other operating expenses are expected to run about P2,000 aonth, including P500 for depreciation. The ending cash balance for 2018 was P4,500.alse lo rinon SalesdinoPurchasesbelio02018 ActualP80,000NovemberDecember om2019 BudgetedJanuaryFebruaryMarchP70,000Hino beoc 90,000inuo 80,000allon vseslse leloT70,00060,000 oeib rias50,00070,00090,00030,000ructions:1 Prepare a cash budget and determine the projected ending cash balances for the first threemonths of 2019.2 Determine the months that the company would either borrow or invest cash.

Budget refers to the statement prepared by the government, individuals, and companies based on the…

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 pałd 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 nth, including P500 for depreciation. The ending cash balance for 2018 was P4,500. Sales Purchases lio 2018 Actual November December P80,000 90,000 P70,000 80,000 allo 2019 Budgeted January February March 70,000 90,000 70,000 60,000 b rie 50,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 that the company would either borrow or invest cash.

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 pałd 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 nth, including P500 for depreciation. The ending cash balance for 2018 was P4,500. Sales Purchases lio 2018 Actual November December P80,000 90,000 P70,000 80,000 allo 2019 Budgeted January February March 70,000 90,000 70,000 60,000 b rie 50,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 that the company would either borrow or invest cash.

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter15: Managing Short-term Assets

Section: Chapter Questions

Problem 1PROB

See similar textbooks

Similar questions

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?
Now assume that it is several years later. The brothers are concerned about the firm’s current credit terms of net 30, which means that contractors buying building products from the firm are not offered a discount and are supposed to pay the full amount in 30 days. Gross sales are now running $1,000,000 a year, and 80% (by dollar volume) of the firm’s paying customers generally pay the full amount on Day 30; the other 20% pay, on average, on Day 40. Of the firm’s gross sales, 2% ends up as bad-debt losses. The brothers are now considering a change in the firm’s credit policy. The change would entail: (1) changing the credit terms to 2/10, net 20, (2) employing stricter credit standards before granting credit, and (3) enforcing collections with greater vigor than in the past. Thus, cash customers and those paying within 10 days would receive a 2% discount, but all others would have to pay the full amount after only 20 days. The brothers believe the discount would both attract additional customers and encourage some existing customers to purchase more from the firm—after all, the discount amounts to a price reduction. Of course, these customers would take the discount and hence would pay in only 10 days. The net expected result is for sales to increase to $1,100,000; for 60% of the paying customers to take the discount and pay on the 10th day; for 30% to pay the full amount on Day 20; for 10% to pay late on Day 30; and for bad-debt losses to fall from 2% to 1% of gross sales. The firm’s operating cost ratio will remain unchanged at 75%, and its cost of carrying receivables will remain unchanged at 12%. To begin the analysis, describe the four variables that make up a firm’s credit policy and explain how each of them affects sales and collections.
Elliott, Inc., has four salaried clerks to process purchase orders. Each clerk is paid a salary of 25,750 and is capable of processing as many as 6,500 purchase orders per year. Each clerk uses a PC and laser printer in processing orders. Time available on each PC system is sufficient to process 6,500 orders per year. The cost of each PC system is 1,100 per year. In addition to the salaries, Elliott spends 27,560 for forms, postage, and other supplies (assuming 26,000 purchase orders are processed). During the year, 25,350 orders were processed. Required: 1. Classify the resources associated with purchasing as (1) flexible or (2) committed. 2. Compute the total activity availability, and break this into activity usage and unused activity. 3. Calculate the total cost of resources supplied (activity cost), and break this into the cost of activity used and the cost of unused activity. 4. (a) Suppose that a large special order will cause an additional 500 purchase orders. What purchasing costs are relevant? By how much will purchasing costs increase if the order is accepted? (b) Suppose that the special order causes 700 additional purchase orders. How will your answer to (a) change?
Park and West, LLC, provides consulting services to retail merchandisers in the Midwest. In 2019, they generated $720,000 in service revenue. Their total cost (fixed and variable) per client was $2,500 and they served 115 clients during the year. If operating expenses for the year were $302,000 what was their net income?
On January 1, a flower shop contracts with customers to provide flowers for their wedding on June 2. The total contract price is $3,000, payable in equal installments for the next six months on the first of each month (with the first payment due January 1). How much will be recorded as revenue during the month of April?
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?
Markson and Sons leases a copy machine with terms that include a fixed fee each month of $500 plus a charge for each copy made. The company uses the high-low method to analyze costs. If Markson paid $360 for 5,000 copies and $280 for 3,000 copies, how much would Markson pay if it made 7,500 copies?
All Temps has a policy of always paying within the discount period, and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 80% of its payments are made in the month of purchase and 20% are made the following month. The direct materials budget provides for purchases of $23,812 in February, $23,127 in March, $21,836 in April, and $28,173 in May.What is the balance in accounts payable for April 30, and May 31?
Peggy Nolan earns 20 per hour for up to 300 units of production per day. If she produces more than 300 units per day, she will receive an additional piece rate of .5333 per unit. Assume that her hours worked and pieces finished for the week just ended were as follows: a. Determine Nolans earnings for each day and for the week. (Round piece-rate computations to the nearest whole dollar.) b. Prepare the journal entry to distribute the payroll, assuming that any make-up guarantees are charged to Factory Overhead.
Dream Big Pillow Co. pays 65% of its purchases in the month of purchase, 30% the month after the purchase, and 5% in the second month following the purchase. It made the following purchases at the end of 2017 and the beginning of 2018:
On March 1, 2019, Elkhart enters into a new contract to build a specialized warehouse for 7 million. The promise to transfer the warehouse is determined to be a performance obligation. The contract states that if the warehouse is usable by November 30, 2019, Elkhart will receive a bonus of 600,000. For every week after November 30 that the warehouse is not usable, the bonus will decrease by 150,000. Elkhart provides the following completion schedule: Required: 1. Assume that Elkhart uses the expected value approach. What amount should Elkhart use for the transaction price? 2. Assume that Elkhart uses the most likely amount approach. What amount should Elkhart use for the transaction price? 3. Next Level What is the purpose of assessing whether a constraint on the variable consideration exists?
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.