Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

My Time, Inc. markets high quality sundials all over the world. The firm has a contract with an artisans' co-op in Greece and is able

image text in transcribed

image text in transcribed

My Time, Inc. markets high quality sundials all over the world. The firm has a contract with an artisans' co-op in Greece and is able to acquire a wide variety of sundials at a fixed price. At the end of 2020, the firm reported the following balance sheet Cash $13,200 A/R 252,800 Inventory 20,400 Equipment (net) 221,228 A/P Loan Payable Common Shares Retained Earnings $360,000 20,000 50,000 77,628 My Time prepares rolling budgets for the upcoming three months. Information for the budget for the first quarter of 2021 follows: The firm predicted unit sales for January, February, March and April of 3,500, 5,000, 4,000 and 4,500 respectively. The firm has a policy of keeping inventory on hand of 15% of the following month's sales. The firm maintains a minimum balance in the cash account of $20,000. 80% of all sales are on account. Of the sales on account, 30% are collected in the month of the sale, 40% are collected in the following month and 25% are collected in the month after that. The cost per unit is $40. In addition to product cost, the firm incurs commissions of 5% of sales, depreciation on equipment of 8,400 per month, administrative costs of 3% of sales, rent of $82,000 per month and insurance of $26,000 per month. All purchases are on account. 40% of purchases are paid for in the month following the purchase and the remaining 60% are paid for two months after the purchase. Actual sales for the month of November were 8,000 units and actual sales for December were 3,000 units. Actual purchases in November were $300,000 and actual purchases in December were $100,000. The price per unit is $80 The firm can borrow money from the bank at any time. The loan carries an interest rate of 3% (per year). Any borrowing must take place at the beginning of the month in which the funds will be required. Any repayments must take place at the end of the month in which they will become possible. Interest must be paid each month on the amount outstanding as of the end of the prior month. 1. Prepare a sales budget in proper format. 2. Prepare a purchases budget in proper format. 3. Prepare a cash collections budget in proper format. 4. Prepare a cash disbursements budget in proper format. 5. Prepare a cash budget in proper format

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

Auditing IT Infrastructures For Compliance

Authors: Robert Johnson, Marty Weiss, Michael G. Solomon

3rd Edition

1284236609, 9781284236606

More Books

Students also viewed these Accounting questions

Question

=+2.4. Let F1, F2, ... be classes of sets in a common space 2.

Answered: 1 week ago

Question

What would you do?

Answered: 1 week ago