Question
Corporation XYZ manufactures and sells office supplies. The financial analyst prepared a budget of purchases for February through June. This will be used in preparation
Corporation XYZ manufactures and sells office supplies. The financial analyst prepared a budget of purchases for February through June. This will be used in preparation of the income statement, cash flow statement, and balance sheet.
Based on the information in the exhibit, calculate the amounts requested below for April. Enter the appropriate amounts in the associated cells. Enter all amounts as positive values. Round amounts to the nearest hundredth.
Entry | Amount |
1. Purchase budget (dollars) | |
2. Cash payments to vendors | |
3. Accounts payable | |
4. Cost of goods sold |
To: Noah Hatton, CEO
From: Robin Johnson, Purchasing department manager
Subject: Purchase budget
Date: July 27, Year 6
Dear Noah,
I prepared a purchases and cash payments budget for February through June. The information is presented below.
Data | February | March | April | May | June |
Unit sales | 100 | 160 | 200 | 260 | 300 |
Inventory balance | 15% of next months budgeted sales | ||||
Selling price | $28 | ||||
Unit cost | $18 | ||||
Payments on payables | 40% in the month of purchase | ||||
60% in the month following the purchase |
Best,
Robin
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started