Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Koffi Cup is a locally-owned caf which sells many selection of freshly-brewed coffee. Koffi has the following information for the November and December of

image text in transcribed

Koffi Cup is a locally-owned caf which sells many selection of freshly-brewed coffee. Koffi has the following information for the November and December of the current year: Budgeted sales for November are 15,000 cups and 22,000 cups in December. Each cup sells for RM6.50. Half of sales are on cash. The company expects to collect 80% of credit sales in the month of the sale and 20% in the month after the sale. All necessary raw materials are purchased on account. Purchases are paid 60% in the month of the purchase and 40% in the following month. Purchases for November are estimated to be RM120,000 and RM210,000 in December. Monthly expenses include: . Wages RM12,000 Rent RM2,000 Utilities RM2,500 Insurance RM1,500 Depreciation RM1,800 . Cash balance on November 1st was RM5,000. The company has a policy to maintain a minimum cash balance of RM5,000. If necessary the company will borrow to meet its short-term needs. All borrowing is done at the beginning of the month and all payments on principal and Interest are made at the end of the next month. The annual interest rate is 7%. The company must borrow in multiples of RM1,000. October sales were 18,000 cup and raw materials purchased equal RM140,000. Required: Prepare a cash budget for November and December. (22 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Financial Accounting

Authors: J. David Spiceland, Wayne Thomas, Don Herrmann

3rd edition

9780077506902, 78025540, 77506901, 978-0078025549

Students also viewed these Accounting questions

Question

In a system with light damping (c Answered: 1 week ago

Answered: 1 week ago