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
Prepare a cash budget for August, September, October, and November. What are total cash inflows in September? (Round to the whole number. ) What are total cash disbursements in October? (Round to the whole number. ) What is the surplus(additional funds needed) in September? (Round to the whole number.)What is the cash balance at the end of November? (Round to the whole number. )

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_2

Step: 3

blur-text-image_3

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

Global Marketing

Authors: Svend Hollensen

8th Edition

1292251808, 9781292251806

More Books

Students also viewed these Accounting questions

Question

Identify the major barriers to developing international brands.

Answered: 1 week ago