Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ubi Soft Entertainment is one of the top ten video game publishers in the world. The company is in the process of developingits cash budget

Ubi Soft Entertainment is one of the top ten video game publishers in the world. The company is in the process of developingits cash budget for the critical pre-Christmas period(August-November) when it makes about 60% of its sales. 20% of sales are cash; 55% are credit and collected the following month and the remainder is collected two months after the sale.
Purchases of raw materials are made in the month prior to the expected sale and average 55% of expected sales. Purchases are paid for in the month following the purchase. Overhead, administration and other expenses are expected to be $257,000 in August and increase by $27,000 in each of the subsequent months. Taxes are $34,000 per month. Interest is $5,000 per month. Cash on hand on July 31 is $53,000. The company likes to maintain a minimum cash balance of $53,000 each month. Actual sales for June and July as well as forecasted sales to the end of the year are provided in the table below.
Month
Sales
June
$930,000
July
840,000
August
1,470,000
September
1,740,000
October
2,280,000
November
2,430,000
December
1,220,000
answer the following questions.
What are total cash inflows in September? (Round to the whole number.
what are the total cash disbursements in October ?
what is the surplus (addistional funds needed) in September?
what is the cas balance at the end of November?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accountancy And The Changing Landscape Of Integrated Reporting

Authors: Ioana Dragu

1st Edition

1522536221, 9781522536222

More Books

Students also viewed these Accounting questions