Question
In-tech Corporation's sales and purchases for the last three months are as following: sale ($) and Purchase ($) October 100,000 (sale) 80,000 (purchase) November 90,000
In-tech Corporation's sales and purchases for the last three months are as following: sale ($) and Purchase ($)
October 100,000 (sale) 80,000 (purchase)
November 90,000 (sale) 100,000 (purchase)
December 120,000 (sale) 75,000 (purchase)
For the next three months, it estimates sales and purchases to be as following: Sales ($) and Purchases ($)
January 90,000 (sale) 70,000 (purchase)
February 80,000 (sale) 70,000 (purchase)
March 80,000 (sale) 70,000 (purchase)
It pays 40 percent of purchases in cash and gets a 4 percent discount. Another 40 percent of purchases are paid the next month, and the final 20 percent of purchases are paid in the second month after the purchase (for example, 40 percent of October purchases are paid in October, 40 percent October purchases are paid in November, and 20 percent October purchases are paid in December). Half of the sales are made in cash, and the balance is collected the next month. Cash sales are given a two percent discount, and five percent of credit sales end up as bad debt. The monthly operating expenses for In-tech Corporation's are $10,000. In-tech expects to sell one of its machinery in March for $25,000. It will buy the replacement in April for $50,000. The cash balance as on December 31 was $50,000. In-tech has a target cash balance of $50,000. Prepare a monthly cash budget for the next three months
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started