Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q4. The following are the sales forecast for Lovely Toy Ltd. For the next three months (15) Month Expected sales January February March Rs.20,00,000 Rs.16,00,000
Q4. The following are the sales forecast for Lovely Toy Ltd. For the next three months (15) Month Expected sales January February March Rs.20,00,000 Rs.16,00,000 Rs.10,00,000 The following additional information is provided: Thirty percent of the company's sales are for cash and the remaining are collected in the month following the sale. Cost of sales amount to 75 percent of sales. Out of which 40 percent are raw material costs and 60 percent are direct labor costs. Direct labor costs are paid in the month incurred. Raw materials are paid in the month following the purchase. Total of other operating expenses amount to Rs.3, 00,000 per month A capital expenditure of Rs. 1, 50,000 has been planned in February. Tax payments of Rs.1, 80,000 are to be made in March. The company maintains a cash balance equal to 10 percent of the previous months cost of sales. The surplus cash is invested in bank deposits based on future requirements. Sales in the month of December were Rs.21,00,000. You are required to prepare a cash budget for the next three months
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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