The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash Accounts receivable Inventory Building and equipment, net Accounts payable. Common stock $8,000 $20,000 $36,000 $120,000 $21,750 $150,000 $12,250 Using the data provided above, use the Excel Template provided to prepare the following budget schedules: 1. Sales Budget (Merely enter the sales data provided.) 2. Schedule of Expected Cash Collections 3. Merchandise Purchases Budget 4. Schedule of Expected Cash Disbursements - Merchandise Purchases 5. Schedule of Expected Cash Disbursements - Selling and Administrative Expenses 6. Cash Budget Retained earnings a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual). $50,000 $60,000 April May June July $72,000 $90,000 $48,000 c. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales. d. Each month's ending inventory should equal 80% of the following month's budgeted cost of goods sold. e. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory. f. Monthly expenses are as follows: commissions, 12% of sales; rent, $2,500 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $900 per month (includes depreciation on new assets). g. Equipment costing $1,500 will be purchased for cash in April. h. Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash Accounts receivable Inventory Building and equipment, net Accounts payable. Common stock $8,000 $20,000 $36,000 $120,000 $21,750 $150,000 $12,250 Using the data provided above, use the Excel Template provided to prepare the following budget schedules: 1. Sales Budget (Merely enter the sales data provided.) 2. Schedule of Expected Cash Collections 3. Merchandise Purchases Budget 4. Schedule of Expected Cash Disbursements - Merchandise Purchases 5. Schedule of Expected Cash Disbursements - Selling and Administrative Expenses 6. Cash Budget Retained earnings a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual). $50,000 $60,000 April May June July $72,000 $90,000 $48,000 c. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales. d. Each month's ending inventory should equal 80% of the following month's budgeted cost of goods sold. e. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory. f. Monthly expenses are as follows: commissions, 12% of sales; rent, $2,500 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $900 per month (includes depreciation on new assets). g. Equipment costing $1,500 will be purchased for cash in April. h. Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 978-0697789938
13th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
Splish Brothers Inc. borrows $86,400 on July 1 from the bank by signing a $86,400, 10%, 1-year note payable (a) Prepare the journal entry to record the proceeds of the note. (Credit account titles...
-
3. Calculate the work done, W=mgh for a mass of 300 g. Then, using the accepted value for the specific heat of water, calculate the change in heat, Q=cmAT for the same data point. a) Calculate the...
-
. 4. Bank overdrafts repayable on * 1 point demand may be included in the cash and cash equivalent balance. True O False
-
Suppose a random variable Y has CDF Find each of the following (a) P(Y (b) P(0.5 (c) The PDF of Y (d) Use the Parabolic Rule with n = 8 to approximate E(Y). 0. if y <0 if y > 1
-
What is a variety of demographic, cultural, and personal differences among people in an organization called? a. Diversity b. Minorities c. Employment equity d. Social integration
-
The type of model building used by Pauling and by Watson and Crick involved the use of ball-and-stick units. Model building can now be done with computer software. Even though you may not be familiar...
-
Founded in 1970, ABC is one of the worlds largest insurance companies with locations in 28 countries. Given the following description, flowchart the new policy setup process as it existed in 1970;...
-
3 Eight students were asked to estimate the mass of a bag of sweets in grams. First they were asked to estimate the mass without touching the bag and then they were told to pick the bag up and...
-
b) Fill in blank spaces in Table 1b and interpret the results. Given the following marketing report from a production firm, answer the following questions. Table 1a Confirmatory Specification with...
-
What role does culture play in shaping societal formations and dynamics, as shared beliefs, practices, and cultural artifacts mediate social relations and collective experiences within a given...
-
Louise Gendron's monthly gross income is $4,200. Her employer withholds $630 in federal and provincial income taxes, $198.68 towards the Canada Pension Plan, and $56.67 for EI contributions. Louise...
-
Explain how Common Notions 1 and 4 may be interpreted as the transitiveand reflexive properties. Also,show that the symmetric property follows from Euclids Common Notions 1 and 4. 1. Things which are...
-
Apple invested 2 million dollars in design plans for the new Apple TV product but the design was never implemented due to external economic issues. Management is currently evaluating whether to...
-
Which e-commerce platform will you use to market your product? Why will you use the e-commerce platform you selected? explain it for smart watches
-
Did Florida Blue do the right thing opening these stores at the risk of upsetting their traditional intermediary channel partners? Why or why not? How seriously should Florida Blue consider the...
-
Comptech Ltd is a manufacturer of optical equipment. In September 2019, Ed Thompson the Chief Research Officer, attended a conference in Switzerland that focused on optical developments for the 21st...
-
Define a sampling strategy.
-
Control is an important element in any type of research. Considering experimental research, come up with a hypothetical research scenario and apply each of the five types of control to the scenario....
-
Identify a hypothetical population .
Study smarter with the SolutionInn App