Reference no: EM13509277
Angelo Diaz has decided to go into business selling colourful scarves which are popular among university students. He will operate the business out of a flea market, mostly on weekends. He is trying to get himself organised for the start of the first quarter. In order to do so, he will have to prepare a few budgets. Use the following information to help him achieve his goal.
Angelo estimates expected sales for January to be £800, February £1200, March £2000 and April £3,000. Gross profit ratio is 0.4. Sixty percent of the next month's sales should be kept in ending finished goods inventory.
Angelo has decided to pay himself a monthly salary of £150. He will pay his best friend £60 to help him with miscellaneous errands. He estimates that general operating costs will be £130 monthly. In addition, since his cousin is the owner of the flea market, he will only pay £100 per month in rent. Upgrading of the space will cost £500, of which £200 will be paid in January and £300 in February. All other costs must be paid for as incurred. He will begin January with £400 in the bank. Forty percent of sales are paid for in cash. The rest is put on credit: 5% of credit sales will not be received, 30% will be paid in the month of sale and 10% of those who pay in the month of sale will qualify for a 20% discount. Another 20% will be received the month following the sale and 5% the second month following the sale.
Thirty percent of the payments for merchandise are made in the month of purchase and the remaining 70% are made in the month following the purchase.
Interest is charged at a rate of 24% per year and payments of interest only are due at the end of each quarter. All loans are borrowed at the very beginning of the month and payments are made at the very end of the month. Angelo must maintain a minimum cash balance of £1,000.
Complete the following:
Help Angelo by completing the following:
1. Prepare a schedule of cash receipts for the first quarter.
2. Prepare a schedule of inventory purchases for the first quarter.
3. Prepare a schedule of cash disbursements for the first quarter.
4. Prepare a cash budget for January and February.
5. How much interest is owed on February 28?
|
What will be the density of the wire you fashion
: You have been given 1.752 g of copper from which you are to fashion a wire whose resistance is 2.519 ohms. What will be the density of the wire you fashion
|
|
Calculate break-even in pounds
: Calculate break-even in units, calculate break-even in pounds if the sales price increases by 10% and fixed costs increase by £12,000.
|
|
What is the incremental revenue associated with accepting
: However, Core is operating at capacity and will incur an additional $55,000 in fixed manufacturing overhead if the order is accepted. What is the incremental revenue associated with accepting the special order?
|
|
Find the distance that the first sled traveled up incline
: A frictionless plane is 10.0 m long and inclined at 34.0°. A sled starts at the bottom with an initial speed of 5.90 m/s up the incline. find the distance that the first sled traveled up the incline
|
|
Prepare a schedule of cash disbursements for the quarter
: Prepare a schedule of cash receipts for the first quarter, prepare a schedule of inventory purchases for the first quarter and prepare a schedule of cash disbursements for the first quarter.
|
|
What is the profitability index of the project
: You are considering a project that has an initial cost of $1,200,000. If you take the project, it will produce net cash flows of $300,000 per year for the next six years. If the appropriate discount rate for the project is 10 percent, what is the ..
|
|
Calculate break-even and prepare a cash budget for january
: Calculate break-even in units - calculate break-even in pounds if the sales price increases by 10% and fixed costs increase by £12,000.
|
|
Determines that fells balance is uncollectible
: The ledger of Hixson Company at the end of the current year shows Accounts Receivable $120,000, Sales $840,000, and Sales Returns and Allowances $30,000.
|
|
Determine the fundamental frequency for this pipe
: You have an organ pipe that resonates at frequencies of 800, 1120, and 1440 Hz but nothing between these. determine the fundamental frequency for this pipe
|