Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Just find the solutions for the image at the bottom. Format it the same way as image please. Near the end of 2017, the management

image text in transcribed Just find the solutions for the image at the bottom. Format it the same way as image please.

Near the end of 2017, the management af Dimsdale Sports Co a merchandising compsny, prepared the following estimsted balance aheetfor December 31 2017 557,000 3,00 Taxa py3/19/2013 To prepare a. The company's single product s purchased for $30 per unit snd resold for $52 per unit. The expected Inventory level of 4,750 units b. Cash sales and crechtsdes represent 25% and 7556, respectively, of total sales. Of the credit sales, 61%) c. Merchandise purchases 5re paid for dG follows: 20% In the first montn fter the month of purchase master budget for January February, and March of 2018, management gsther; the folowing information on Decent er 31 2017, more than managememt's ces red level, whicn l 20% of the next month's expected sales (in units Expected se are: Janusry, 7,250 unlts; February, 9,000 units; March, 11,250 unlts; and April, 10,000 unta collected in the first month 5fter the month of sale and 39% in the second month 5fter the month of sale. Forthe December 31, 2017, ccounts recelvsble balance, $130,000 s colected in January and the remaining $390,000 s colected In February a056 in the second month ter the month of purchase For the December 31 2017, sccounts psyable balance,$95,000 ts pald In January and the remaining $270,000 pad In Februsry. d. Sales commlaalons equa to 20% of sales re pald each month, Sales soares (excluding commissions) are $90,000 per year e. General and administrative salarles are $144,000 per yesr. Maintensnce expense equals $2100 per morth and s pald in cssh t Equipment reported in the December 31, 2017, beance sheet w52 purchased in January 201 being deprecisted over eight years underthe stra ght-lne method with no sslvage vslue. The following amounts for new equlpment purchases are planned tin the coming quarter: January, $38,400 February, $100,800and March, $21,600. Thls equipment will be depreciated under the strslght- rne method over eight years with no sshvage v lue. A full month's depreclation!, taken forthe month in which equipment g. The company plans to buy land at the end af March sts cost of $170,000, which will be pald with cash on the last day of the month h. The company has working rrangement with ts bank to ootin 5dchtonal loanG 5G needed. The interest rate is 12% per year, and terest pald st esch month-end based on the begnning balance Partal or full payments on these loans can be made on the last day of the month. The company has agreed to mentaln minimum ending cash balance of $24,690the end of each mort. L The income tax rte for the company 1 39% Income t3xes on the first quarter's income wil not be paid until April 15. Prepare master budget for each of the first three months of 2018; include the following component budgets: 1. Manthly sales budgets. 2 Monthy merchandse purchases budgets. 3. Monthly selling expense budgets 4. Monthy general and administrative expense budgets 5. Monthly capital expenditures budgets. 6. Monthly cash budgeta 7 Budgeted Income ststement for the entire first quarter (nat for esch manth B. Budgeted balance sheet as of March 31, 2019. Complzte this question by entering your answers In the tabs below. Monthly cap tal epandures budgets January, February, and Maroh 2013 Required 4 Required 6Cak

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

Students also viewed these Accounting questions