The controller of Digital Storage, Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:
| April | May | June | |
| Sales | $90,000 | $140,000 | $150,000 |
| Manufacturing costs | 42,000 | 48,000 | 50,000 |
| Selling and administrative expenses | 35,000 | 36,000 | 40,000 |
| Capital expenditures | — | — | 60,000 |
The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in full in the month following the sale and the remainder the following month. Depreciation, insurance, and property tax expense represent $20,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in July, 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 April 1 include cash of $40,000, marketable securities of $65,000, and accounts receivable of $109,600 ($85,000 from March sales and $24,600 from February sales). Current liabilities as of April 1 include $50,000, 12%, 90-day note payable due June 20 and $25,000 of accounts payable incurred in March for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. It is expected that $3,000 in dividends will be received in April. An estimated income tax payment of $32,000 will be made in May. Digital Storage’s regular quarterly dividend of $10,000 is expected to be declared in May and paid in June. Management desires to maintain a minimum cash balance of $35,000.
Instructions
- Prepare a monthly cash budget and supporting schedules for April, May, and June.
- On the basis of the cash budget prepared in (1), what recommendation should be made to the controller?
Also read:
- It is late June, and Sandra Huchim, head of operations at Mintendo, and Bill Smith, head of salesof We “R” Toys, are about to get together to discuss production and marketing plans for the next6 months. Mintendo is the manufacturer of the popular Game Girl handheld electronic game that is sold exclusively through We “R” Toys retail stores. The second half of the year is critical toGame Girl’s success, because a majority of its sales occur during the holiday shopping period.Sandra is worried about the impact that the upcoming holiday surge in demand will have on herproduction line. Costs to subcontract assembly of the Game Girls are expected to increase, andshe has been trying to keep costs down, given that her bonus depends on the level of productioncosts.Bill is worried about competing toy stores gaining share in the handheld electronic game marketduring the Christmas buying season. He has seen many companies lose their share by failing tokeep prices in line with the performance of their products. He would like to maximize the GameGirl market share in the handheld electronic game market.Both Sandra’s and Bill’s teams produce a joint forecast of demand over the next six months, asshown in Table 9-7.We “R” Toys sells Game Girls for $50 apiece. At the end of June, the company has an inventoryof 50,000 Game Girls. Capacity of the production facility is set purely by the number of workersassembling the Game Girls. At the end of June, the company has a workforce of 300 employees,each of whom works 8 hours of regular time at $15/hour for 20 days each month. Work rulesrequire that no employee work more than 40 hours of overtime per month. The various costs areshown in Table 9-8.Sandra, concerned about controlling costs during the periods of surging demand over theholidays, proposes to Bill that the price be lowered by $5 for the month of September. Thiswould likely increase September’s demand by 50 percent due to new customers being attractedto Game Girl. In addition, 30 percent of each of the following two months of demand wouldoccur in September as forward buys. She believes strongly that this leveling of demand will helpthe company.Bill counters with the idea of offering the same promotion in November, during the heart of thebuying season. In this case, the promotion increases November’s demand by 50 percent, owingto new customers being attracted to Game Girl. Additionally, 30 percent of December’s demandwould occur in November as forward buying. Bill wants to increase revenue and sees no betterway to do this than to offer a promotion during the peak season.a. Which option delivers the maximum profit for the supply chain: Sandra’s plan, Bill’splan, or no promotion plan at all?b. How does the answer change if a discount of $10 must be given to reach the samelevel of impact that the $5 discount received?c. Suppose Sandra’s fears about increasing outsourcing costs come to fruition and thecost rises to $22/unit for subcontracting. Does this change the decision when thediscount is $5? need to be able to explain how i got the answer not necessary to show all work but this one is giving me fits.
- principles of economics Which statement is true? A) Today more workers in the U.S. are members of labor unions than any time in our history. B) Today labor unions are weaker than any time in the last 100 years. C) No major labor union has called a strike since the 1940s.D) Labor unions are relatively strong in the public (government) sector. 2. Exclusive union strategy involves A) increasing the demand for the final product, thereby increasing the demand for labor. B) restricting the supply of union labor. C) setting job standards and entry qualifications for members. D) organizing all workers and bargaining for a wage.E) negotiating only after a strike has been called. 3. An example of an exclusive union would be A) the International Brotherhood of the Teamsters. B) the Communications Workers of America. C) the American Medical Association. D) the United Steel Workers. 4. In which one of these years was labor union membership the highest? A) 1940 B) 1960 C) 1980 D) 1990 5. Which of the following laws stated that attempts to monopolize, conspiracies in restraint of trade, and conspiracies to monopolize were illegal? A) The Federal Trade Commission Act B) The Clayton Act C) The Sherman Antitrust Act D) All of the choices. E) None of the choices 6.Until the passage of the Airline Deregulation Act of 1978, the Civil Aeronautics Board controlled all of the following except A) fares. B) assigned routes. C) profits. D) entry into the industry. 7. The Clayton Act prohibited A) interlocking directorates. B) all forms of monopoly. C) foreign control of U.S. corporations. D) false and deceptive advertising. 8. Which statement is true? A) Microsoft is subject to American antitrust laws, but not those of Europe, Asia, or elsewhere. B) Microsoft has never been involved in an antitrust suit. C) The European Commission fined Microsoft over $600 billion for its anticompetitive behavior. D) Microsoft has always gone out of its way to be helpful to its competitors. 9. A monopolist operates at the minimum point of her ATC curve A) only in the short run. B) only in the long run. C) in both the short run and the long run. D) in neither the short run nor the long run. 10. Which of the following is characteristic of a monopoly? A) The absence of political power B) Close substitute products C) The ability to make an economic profit in the long run D) Operating at peak efficiency. (I will send the image) 11. This firm will charge a price of A). $8. B) $9.65. C) $10. D) $12. E) $16 12. Statement I. Only natural monopolies are legal in the United States. Statement II. Large firms generally operate at peak efficiency. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 13. The nation's largest bank has assets over A) $2.5 billion. B) $25 billion. C) $250 billion. D) $800 billion. E) $1.8 trillion. 14. Which statement is true? A) Our money supply is fixed by law and can be raised by only a very small percentage each year. B) Our money supply is backed by gold. C) Credit cards are a form of money. D) Money makes an excellent store of value during times of inflation. E) One of the basic jobs of money is a standard of value. 15. The first bankers were A) goldsmiths. B) printers. C) storekeepers. D) innkeepers. E) blacksmiths. 16. Suppose you had no money in your checking account and your bank granted you overdraft privileges. You then went out and charged $20 on your debit card. How much would your bank charge you in fees for using your overdraft privileges? A) 0 B) $5 C) 15 D) 35 E) $50 17. Statement I: John Maynard Keynes called the hoarding of money at very low interest rates a "liquidity trap." Statement II: Since the late 1990s, Japan has been caught in a liquidity trap. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 18. Banks can A) create money, but not destroy money. B) destroy money, but not create money. C) create and destroy money. D) neither create nor destroy money. 19. The Federal Open Market Committee is made up of all of the following, except A) the board of governors. B) the chairman of the board of governors. C) the president of the United States. D) the president of the Federal Reserve Bank of New York. E) the presidents of four Federal Reserve Banks other than the New York Bank. 20. The Federal Reserve System A) has regional Federal Reserve Banks that make most of the decisions. B) makes decisions subject to the approval of the President. C) makes its major policy decisions in its Open Market Committee. D) makes decisions subject to the approval of Congress. 21. With economic development comes each of the following, except A) a decline in the birth rate. B) an increase in the stock of capital. C) rising per capita GDP D) a declining wage rate. 22. Our educational standards today. A) are the highest in history. B) are much higher than they were 50 years ago. C) are the same as they were 50 years ago. D) are much lower than they were 50 years ago. 23. Brazil should be classified as a(n) A) very poor LDC. B) middle-rank LDC. C) NIC. D) industrial country. 24. The most important reason for our slow rate of productivity growth over the last three decades (of those listed below) is A) lagging business sales. B) foreign imports. C) our low savings rate. D) high tax rates. 25. Structural unemployment occurs when A) workers have quit one job and are looking for a better one. B) high school graduates enter the labor market every June. C) the business cycle is in a downturn and people are laid off. D) the people without jobs have skills that don't match the available job openings. 26. Unemployment caused by economic decline or recession is called A) frictional unemployment. B) cyclical unemployment. C) natural unemployment. D) necessary unemployment. E) structural unemployment.. 27. The recession of 2001 was caused by A) the events of 9/11. B) a decline in consumer spending. C) a decline in investment spending. D) the war in Iraq. 28. A budget deficit is the A) annual excess of government spending over revenue raised by taxes, fees, and charges. B) shortfall of Social Security collections toward payment of benefits. C) amount by which tax revenues and borrowed funds fall short of government expenditures. D) excess of tax revenues over expenditures. E) amount by which tax revenues exceed borrowed funds. 29. The consumer price index is created by A) calculating the cost of a "basket" of consumer goods typically bought by an American family in any year as a percentage of their cost in a base year. B) the Congressional Budget Office. C) averaging the price increases for all consumer goods in the GDP and adding 100. D) dividing nominal dollar consumer expenditures by base year consumer expenditures. 30. Statement I: When equilibrium GDP and full employment GDP are equal, there is no inflationary gap and no deflationary gap.Statement II: Equilibrium GDP is an ideal goal that can never be attained. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 31. When government expenditures in a given year are less than tax receipts, there exists A) a budget deficit. B) public revenue. C) full-employment taxation. D) a budget surplus .32. As price rises, the quantity ______________ rises. A) demanded B) supplied C) demanded and supplied 33. If the MPC were .75, what change in government spending (in billions of dollars) would be required to cause the equilibrium level of GDP to fall by 100? A) A decrease of 25. B) A decrease of 50. C) A decrease of 75. D) A decrease of 100. E) A decrease of 125. (I will send the image) 34. When price is $8 A) quantity demanded is greater than quantity supplied and, therefore, price must fall to get to equilibrium price. B) quantity demanded is greater than quantity supplied and, therefore, price must rise to get to equilibrium price. C) quantity supplied is greater than quantity demanded and, therefore, price must fall to get to equilibrium price. D) quantity supplied is greater than quantity demanded and, therefore, price must rise to get to equilibrium price. 35. Usury is considered the charging of A) higher interest rates than people are willing to pay. B) lower interest rates than people are willing to pay C) unconscionably high interest rates. D) extremely low rates of interest. 36. The present value of a dollar rises as A) the interest rate declines and the number of years you wait for your money declines. B) the interest rate rises and the number of years you wait for your money rises. C) the interest rate declines and the number of years you wait for your money rises. D) the interest rate rises and the number of years you wait for your money declines. 37. In economics we say the amount of land is A) fixed. B) variable. C) both fixed and variable. D) neither fixed nor variable. 38. Which is not determined by supply and demand? A) The wage rate B) The interest rate C) Rent D) Profits 39. Which of the following is false? A) The supply of land is fixed. B) When the demand for a plot of land rises, its supply will rise. C) Land is most efficiently used in cities. D) The rent on a particular piece of land is based on the MRP schedule of the highest bidder. 40. If you knew that interest rates would be rising, then you would predict that the present value of $1 received 5 years from now A) would be higher. B) would be about the same. C) would be lower. D) could be higher or lower. 41. Changes in rent on a plot of land are chiefly due to A) changes in demand. B) changes in supply. C) changes in both demand and supply. D) changes in neither supply nor demand. (I will send the image) 42. The horizontal dotted line is A) a price ceiling. B) a price floor. C) either a price ceiling or a price floor. D) neither a price ceiling nor a price floor. 43. These lenders avoid using the term "interest," but their borrowers still do pay a charge for borrowing money. This would be considered ___________ lending. A) Islamic B) payday C) fringe D) sub-prime 44. __________ sees the entrepreneur as an exploiter of labor. A) Joseph Schumpeter B) Frank Knight C) Henry George D) Karl Marx 45. A more equal distribution of income A) might hurt the incentive to work .B) would not hurt the incentive to work C) would be opposed by nearly all Americans D) would hurt the poor. 46. Between 1994 and 2005 our welfare rolls A) declined substantially every year. B) declined slightly every year .C) declined most years. D) stayed about the same. E) rose most years 47.Who expressed this view? "Unlike the present period, (black) inner-city communities prior to 1960 exhibited the features of social organization—including a sense of community, positive neighborhood identification, and explicit norms and sanctions against aberrant behavior." A) Charles Murray B) William Julius Wilson C) Mickey Kaus D) Lisabeth Schorr E) Celia Dugger 48. According to Darity and Myers A) black men are becoming increasingly marginal to our economy B) the basic cause of poverty is welfare dependency C) the best solution to poverty is the negative income tax D) as our economy continues to expand, black poverty will decline (I will send the image) 49. The percentage share of income of the bottom quintile on curve X is A) 0. B) 5. C) 10. D) 15. E) 20. 50. The percentage of people living in poverty in 2006 in the U.S. was _______. A) 6 B) 11.7 C) 12.3 D) 15.2 51. Child poverty is A) much more of a problem in France, Germany, and Japan than it is in the U.S. B) less of a problem in the United States than in Canada, Britain, or Italy. C) more of a problem in Sweden, Denmark, and Ireland than it is in the U.S. D) much more of a problem in the U.S. than in virtually all other industrialized countries. 52. Statement I: Social Security payments help mostly the poor. Statement II: Poverty may be defined as a relative concept and as an absolute concept. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 53. Compared to their levels in 1999, the poverty line has ______ and the minimum hourly wage has ________. A) gone up; gone up B) stayed the same; stayed the same C) gone up; stayed the same D) stayed the same; gone up 54. In which year was the poverty rate the lowest? A) 1960 B) 1973 C) 1984 D) 1993 E) 2006 55. Which statement is true? A) Most economists support rent control laws. B) Usury laws and rent control are price ceilings. C) Usury laws have never had any effect because they are set well above interest rates. D) None of the choices. (I will send the image) 56. If price were set by the government at $3, there would be a price _____________, that would cause a ___________ of _______ units. A) floor, surplus, 12 B) floor, shortage, 12 C) ceiling, surplus, 14 D) ceiling, shortage, 14 57. Sue Ann Buchanan, can make $800,000 on the pro tennis tour, but would be willing to do it for $200,000. Her economic rent is A) $200,000. B) $600,000. C) $800,000. D) $1,000,000. 58. Despite their fantastic employment gains, African American men earn ____% of what white men earn. A) 65 B) 55 C) 60 D) 76 59. Since 1996, productivity growth has ________ and real wages have ______. A) risen; risen B) fallen; fallen C) risen; fallen D) fallen; risen. 60. Which statement is false? A) The minimum wage has NOT kept up with the rate of inflation .B) The average real hourly earnings fell steadily from 1973 to 1993. C) Workers with some high school education make about the same average annual earnings as those with high school diplomas. D) It is harder for a middle class student to get a college degree because since 1979, the cost of going to college has gone up twice as fast as the rate of inflation.
- Prepare a monthly cash budget
- Monthly Cash Budget
- You are the Budget Director for Alamo Hospice a mid-size hospice organization. You will develop a comprehensive budget and create the associated performance story for Next Year that describes the results the organization is planning to produce.
- The following information is used for Lucky's Inc."?s monthly master budget
- Prepare a flexible budget for next year for Facebook
- (1) You make monthly payments on a loan. What is the effective monthly