Business, 13.07.2021 16:40 jayloy4724

You are an accountant at Hostell Homewares Inc. The controller wants you to prepare a monthly cash budget for the next three months, based on the following budget information. September October November
Sales $300,000 $350,000 $325,000
Manufacturing costs $175,000 $200,000 $210,000
Selling and administrative expenses $50,000 $50,000 $55,000
Capital expenditures $200,000
The company expects to sell about 10% of its merchandise for cash. Of sales on account, 65% are expected to be collected in the month following the sale and the remainder the following month (second month following the sale). Depreciation, insurance and property tax expense represent $50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 75% are expected to be paid in the month in which they are incurred and the balance in the following month.
Additionally, the following account balances as of September 1….
Current Assets
Cash$50,000
Marketable securities $75,000
Accounts receivable $327,000
July portion of A/R $77,000
August portion of A/R $250,000
Current Liabilities
Accounts Payable $50,000
Other items of note….
Sales on account for….
July $220,000
August $250,000
Selling and administrative costs are paid in the period incurred.
Estimated income tax payment to be made in October$60,000
Regular quarterly dividend declared in October$30,000
Regular quarterly dividend paid in November$30,000
Lastly, Scott's management desires a minimum monthly cash balance of $50,000.
Instructions: Using formulas/functions wherever available, complete the following on the Input tab…
Prepare a monthly cash budget and supporting schedules for September, October, and November.
On the basis of the cash budget prepared in Part 1, what feedback would you give the controller?

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 21:00

Management discovers that a supervisor at one of its restaurant locations removes excess cash and resets sales totals throughout the day on the point-of-sale (pos) system. at closing, the supervisor deposits cash equal to the recorded sales on the pos system and keeps the rest.the supervisor forwards the close-of-day pos reports from the pos system along with a copy of the bank deposit slip to the company’s revenue accounting department. the revenue accounting department records the sales and the cash for the location in the general ledger and verifies the deposit slip to the bank statement. any differences between sales and deposits are recorded in an over/short account and, if necessary, followed up with the location supervisor. the customer food order checks are serially numbered, and it is the supervisor’s responsibility to see that they are accounted for at the end of each day. customerchecks and the transaction journal tapes from the pos system are kept by the supervisor for 1 week at the location and then destroyed.what control allowed the fraud to occur?

Answers: 2

Answer

Business, 21.06.2019 21:30

Recently, verizon wireless ran a pricing trial in order to estimate the elasticity of demand for its services. the manager selected three states that were representative of its entire service area and increased prices by 5 percent to customers in those areas. one week later, the number of customers enrolled in verizon's cellular plans declined 4 percent in those states, while enrollments in states where prices were not increased remained flat. the manager used this information to estimate the own-price elasticity of demand and, based on her findings, immediately increased prices in all market areas by 5 percent in an attempt to boost the company's 2016 annual revenues. one year later, the manager was perplexed because verizon's 2016 annual revenues were 10 percent lower than those in 2015"the price increase apparently led to a reduction in the company's revenues. did the manager make an error? yes - the one-week measures show demand is inelastic, so a price increase will decrease revenues. yes - the one-week measures show demand is elastic, so a price increase will reduce revenues. yes - cell phone elasticity is likely much larger in the long-run than the short-run. no - the cell phone market must have changed between 2011 and 2012 for this price increase to lower revenues.

Answers: 3

Answer

Business, 22.06.2019 17:30

Costco wholesale corporation operates membership warehouses selling food, appliances, consumer electronics, apparel and other household goods at 471 locations across the u.s. as well as in canada, mexico and puerto rico. as of its fiscal year-end 2005, costco had approximately 21.2 million members. selected fiscal-year information from the company's balance sheets follows. ($ millions). selected balance sheet data 2005 2004 merchandise inventories $4,015 $3,644 deferred membership income (liability) 501 454 (a) during fiscal 2005, costco collected $1,120 cash for membership fees. use the financial statement effectstemplate to record the cash collected for membership fees. (b) in 2005, costco recorded $46,347 million in merchandise costs (that is, cost of goods sold). record thistransaction in the financial statement effects template. (c) determine the value of merchandise that costco purchased during fiscal-year 2005. use the financial statementeffects template to record these merchandise purchases. assume all of costco's purchases are on credit.

Answers: 3

Answer

Business, 23.06.2019 01:00

Why does the downward-sloping production possibilities curve imply that factors of production are scarce?

Answers: 1

Answer

You know the right answer?

You are an accountant at Hostell Homewares Inc. The controller wants you to prepare a monthly cash b...

Questions