Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Xcom is a small retailer that sells phone cases. The following estimates are available for the coming period: Month Budgeted Sales (Units) April 40,000 May

Xcom is a small retailer that sells phone cases. The following estimates are available for the coming period: Month Budgeted Sales (Units) April 40,000 May 50,000 June 44,000 Notes: i. Opening cash balance for the month of May is expected to be $9,250. ii. Inventory policy- ending inventory of finished goods equal to 25% of that months sales. iii. Budgeted selling price per case- $40 iv. Purchase price per case - $10 (purchase volume greater than 30,000 cases per month will receive a 5% discount). v. Collections from customers: 80% in the month of sale 20% one month after the sale vi. Monthly operating expenses are budgeted at: Marketing $20,000 per month Sales commission (5% of Total Sales Collection for the month) Administration cost per month is $18,000. This includes depreciation of $2,000 per month. vii. All expenses and purchases are paid in the month incurred unless otherwise specified. Required: For the month of May, you have been asked to prepare: a. Purchases budget in units and dollars (10 marks) b. Sales collection schedule (3 marks) c. Cash Budget (10 marks) d. Explain the meaning of the term Rolling Budget (2 marks)

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

Students also viewed these Accounting questions