Archer electronics company actual sales and purchases

Assignment Help Accounting Basics
Reference no: EM131077039

Archer Electronics Company's actual sales and purchases for April and May are shown here, along with forecasted sales and purchases for June through September. Sales Purchases April (actual) $ 370,000 $ 155,000 May (actual) 350,000 145,000 June (forecast) 325,000 145,000 July (forecast) 325,000 205,000 August (forecast) 340,000 225,000 September (forecast) 380,000 220,000. The company makes 20 percent of its sales for cash and 80 percent on credit. Of the credit sales, 50 percent are collected in the month after the sale, and 50 percent are collected two months later. Archer pays for 20 percent of its purchases in the month after purchase and 80 percent two months after. Labor expense equals 15 percent of the current month's sales.

Overhead expense equals $12,500 per month. Interest payments of $32,500 are due in June and September. A cash dividend of $52,500 is scheduled to be paid in June. Tax payments of $25,500 are due in June and September. There is a scheduled capital outlay of $350,000 in September. Archer Electronics' ending cash balance in May is $22,500.

The minimum desired cash balance is $10,500. Prepare a schedule of monthly cash receipts for June through September. Prepare a schedule of monthly cash payments for June through September. Prepare a complete monthly cash budget with borrowing and repayments for June through September. The maximum desired cash balance is $50,500. Excess cash (above $50,500) is used to buy marketable securities. Marketable securities are sold before borrowing funds in case of a cash shortfall (less than $10,500).

Reference no: EM131077039

Questions Cloud

Natural style of writing for most people : This essay explores the narrative mode, which is perhaps the most natural style of writing for most people. The narrative form has much in common with fiction or creative writing, in that it relies on descriptive language, dialogue, and dramatic a..
Table or chart listing product-price-place : You will analyze the 4 P's for your brand (VictoriaBeckham). Again, the 4 P's was in the reading material (price, product, place, promotion). This can be completed on a table or chart listing product, price, place (online, brick, other, both), and..
Is there a gap in the knowledge that you can fill : A desire to ‘know' more, a passion for a field of study and the motivation to do something for the ‘greater  good' are important for researchers to enjoy and gain satisfaction from their work. Consider this scenario - Does something pique y..
Concerning the sharing of that knowledge : Q1: What steps were taken to consolidate and safeguard the knowledge gained during execution of the Project;  that is, to benefit from "lessons learned?" Q2: What decisions were made concerning the sharing of that knowledge?
Archer electronics company actual sales and purchases : Archer Electronics Company's actual sales and purchases for April and May are shown here, along with forecasted sales and purchases for June through September.
Analyze the key influences that the theoretical aspects : From the weekly readings and e-Activity, predict two to three (2-3) challenges that public leaders will face regarding the future of public leadership. Provide a rationale for your response
Benefits and outcomes of international strategy : Why would companies choose to venture out of their home country? Include the benefits and outcomes of international strategy for a company in your response. Companies may select different modes of entry into the international markets. Discuss some..
What are the five racial groups defined by the act : Are race and color distinctions mutually exclusive under the Civil Rights Act of 1964? Can two persons be of the same race but of different colors under the act? What are the five racial groups defined by the act?
Discuss the different kinds of mobile and wearable devices : The team should get together and discuss the different kinds of mobile and wearable devices (at least two, preferably three or more), research the features and functionality of them, and compare them based on five criteria.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Fasb codification access

1. In the Course Home tab of your course shell, click on "FASB Codification Access."  Scroll to the bottom of the page and click on "For tutorials please click on the link here." Watch and listen to the four tutorial modules and answer the followi..

  Below are the adjusted accoutns of jims electrical service

below are the adjusted accoutns of jims electrical service for the month ended may 31 2013accts. payable 600accts. rec.

  Practice and process of project management

The post-implementation audit is vitally important in improving the practice and process of project management, yet it is always so difficult to get senior management and the client to allocate the time to authorize and participate in these audits..

  Prepare the appropriate journal entry to record lances

lance lawn services reports warranty expense by estimating the amount that eventually will be paid to satisfy

  Who are the five sponsoring organizations

Download the COSO ERM executive summary(free of charge). According to the first page of the summary, what does enterprise risk management encompass?

  Abc company has an effective tax rate of 40 if they have

abc company has an effective tax rate of 40. if they have fixed cost of 30000 and want an after tax profit of 65000

  On january 1 year xxx1 holmes co borrowed cash from legacy

on january 1 year xxx1 holmes co. borrowed cash from legacy bank by issuing an 80000 face value three-year term note

  Value added-nonvalue added-total lead time

Compute the value added, nonvalue added, and the total lead time of the wreath process.

  The following information is available from the records of

the following information is available from the records of prestigelandscape design inc. at the end of the 2008

  Journalize all entries required on the abouve dates

Journalize all entries required on the abouve dates, including entries to update depreciation, where applicable, on assets disposed of. Thomas Company uses straight-line depreciation. (Assume depreciation is uo to date as of Dec 31 2005.

  Entries for reacquisition and resale of stock

On August 10, Jameson Corporation reacquired 8,000 shares of its $100 par value common stock at $134. The stock was originally issued at $110. The shares were resold on November 21 at $145. Provide the entries required to record the reacquisition ..

  What will happen to bobby jones during the civil litigation

Describe what will happen to Bobby Jones during the civil litigation, including the stages of civil litigation that he and ABC will go through.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd