Do not give image format Allan International is in the construction business. In 2010, it is expected that 30 percent of a month'ssales will be received in cash, with the balance being received the following month. Of the purchases, 60percent are paid the following month, 30 percent are paid in two months, and the remaining 10 percent arepaid during the month of purchase.The sales force receives $2,000 a month base pay plus a 4 percent commission. Labor expenses areexpected to be $6,000 a month. Other operating expenses are expected to run about $5,000 a month,including $1,000 for depreciation.The ending cash balance for 2009 was $28,000.2009-ActualNovemberDecember2010-BudgetedJanuaryFebruaryMarchSales$140,000160,000$ 90,00080,000100,000Purchases$ 80,000100,000$ 90,000100,00080,000Prepare a cash budget and determine the projected ending cash balances for the first three months of2010.

Cash budget is an important budget in budgeting in which it represents an organization's cash inflow…

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.

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.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 34E: A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and...

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?
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
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
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.
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?
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.
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?
Cadre, Inc., sells a single product with a selling price of $120 and variable costs per unit of $90. The companys monthly fixed expenses are $180,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of October when they will sell 10,000 units. How many units will Cadre need to sell in order to realize a target profit of $300,000? What dollar sales will Cadre need to generate in order to realize a target profit of $300,000? Construct a contribution margin income statement for the month of August that reflects $2,400,000 in sales revenue for Cadre, Inc.
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.
The Silver Star Bicycle Company will manufacture both mens and womens models for its Easy-Pedal bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 mens and 125 womens models to be shipped during the first month and 200 mens and 150 womens models to be shipped during the second month. Additional data are as follows: Last month, the company used a total of 1,000 hours of labor. The companys labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company would like to have at least 25 units of each model in inventory at the end of the two months. (Hint: Define variables for production and inventory held in each period for each product. Then use a constraint to define the relationship between these: inventory from end of previous period + produced this period demand this period = inventory at end of this period.) a. Establish a production schedule that minimizes production and inventory costs and satisfies the labor-smoothing, demand, and inventory requirements. What inventories will be maintained and what are the monthly labor requirements? b. If the company changed the constraints so that monthly labor increases and decreases could not exceed 50 hours, what would happen to the production schedule? How much will the cost increase? What would you recommend?
Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.