Purchase Solution

Swiss Valley Veterinary Products: Cash Budgeting

Not what you're looking for?

Ask Custom Question

Swiss Valley Veterinary Products distributes animal health care products to commercial livestock producers throughout the United States and Europe. The terms of sale require cash payment within 30 days, and most producers take full advantage of this payment option. Swiss Valley buys health care products on credit from multinational pharmaceutical companies. The credit purchase terms require cash payment within 60 days. Sales are somewhat seasonal. The attached file shows monthly activities for one of Swiss Valley's most important business segment - swine health care products. Cash collection are from customers and cash payments are to suppliers of swine health care products. The figures shown for Accounts receivable, Inventories, and Accounts payable represent month-end amounts. Some December amounts have been omitted for brevity.
Dollar amounts in thousands
Dec Jan Feb Mar Apr May June
Sales 620 650 800 880 940 850
Cost of goods sold 500 520 640 700 750 680
Gross Profit 120 130 160 180 190 170

Accounts Receivable 500 610 630 790 865 925 830
Inventories 600 625 770 840 900 820 660
Accounts Payable 1100 985 1130 1315 1410 1370 1113

Cash collections 510 630 640 805 880 945
Cash payments 640 480 525 665 710 760
Net cash flow -130 150 115 140 170 185

1. Customers in March purchased $800,000 of sine health care products. Of this amount, how much did March customers still owe at month-end?
2. March cash collections totaled $640,000. Explain how this figure was determined.
3. What was the amount of swine health care products purchased in March from pharmaceutical suppliers?
4. March cash payments to suppliers totaled $525,000. Explain how this figure was determined.
*The percentage of sales information was not provided.

Purchase this Solution

Solution Summary

Your tutorial is in Excel and takes you through the logic of how to find the amounts, showing a reconciliation of the activity in accounts receivable and accounts payable as a proof of where the amounts came from.

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.